Microsoft KB Archive/69491

= XL: Cannot Shift Nonblank Cells Off Sheet =

Article ID: 69491

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q69491



SYMPTOMS
When you attempt to inset a cell, row, or column, you receive the following error message:

Cannot shift nonblank cells off sheet



CAUSE
This error message occurs if the last cell, row, or column, in your sheet contains data or is formatted. You receive this error message because the cell or range of cells will be pushed off the sheet if you insert a new cell, row, or column.



WORKAROUND
To work around this issue, follow these steps:
 * 1) Locate the nonblank cell, row, or column that will be pushed off the sheet.

To determine where the nonblank cells are located, press CTRL+LEFT ARROW or CTRL+RIGHT ARROW. These key sequences find the next block of data or the end of a block of data.
 * 1) On the Edit menu, point to Clear, and then click All.

Note that this step removes the contents of the cell, row, or column.

Now you can insert additional cells, rows, or columns.

Additional query words: shade fill font MacXLX Mac XLX XL2001 XL7 XL95

Keywords: kberrmsg kbprb KB69491

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.