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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.