XL: Cannot Shift Nonblank Cells Off Sheet

Article ID: 69491 - View products that this article applies to.
This article was previously published under Q69491
Expand all | Collapse all

SYMPTOMS

When you attempt to inset a cell, row, or column, you receive the following error message:
Cannot shift nonblank cells off sheet
Back to the top | Give Feedback

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.
Back to the top | Give Feedback

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.
  2. 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.
Back to the top | Give Feedback

Properties

Article ID: 69491 - Last Review: November 16, 2006 - Revision: 2.3
APPLIES TO
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
Keywords: 
kberrmsg kbprb KB69491
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top