Excel Err Msg: Cannot Shift Nonblank Cells Off Sheet

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0, 5.0c
• Microsoft Excel for OS/2 versions 2.2, 3.0
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for the Power Macintosh, versions 5.0, 5.0a

SYMPTOMS

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

Cannot shift nonblank cells off sheet

CAUSE

This problem 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 problem:

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.



2. On the Edit menu, click Clear, and then click All.
   
   Note that this step will remove the contents of the cell, row, or column.

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 5.00a 5.00c shade fill font

Keywords          : kberrmsg 
Version           : 2.x 3.00 4.00 4.00a 5.00 5.00c 7
Platform          : OS/2 WINDOWS 
Issue type        : kbprb 

Last Reviewed: March 21, 1999