Microsoft KB Archive/38371

Excel Err Msg: Can't Shift Non-Blank Cells off Sheet Last reviewed: November 2, 1994 Article ID: Q38371

SUMMARY In Microsoft Excel, the error "Can't shift non-blank cell(s) off sheet" occurs while you are trying to insert a cell, row, or column when there is information in the last row or column (row 16,384 or column IV [256]). To insert a row (or a cell when shifting cells down), select row 16,384, choose Clear from the Edit menu, and click OK. To insert a column (or a cell when shifting cells right), select column IV (256), choose Clear from the Edit menu, and click OK.

KBCategory: kbother KBSubcategory: Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00 Last reviewed: November 2, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.