Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL: Cannot Shift Nonblank Cells Off Sheet
Article ID: 69491 - View products that this article applies to.
This article was previously published under Q69491
When you attempt to inset a cell, row, or column, you receive the following error message:
Cannot shift nonblank cells off sheet
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.
To work around this issue, follow these steps:
Article ID: 69491 - Last Review: November 16, 2006 - Revision: 2.3