MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Error

Posted by Sunny on September 14, 2001 10:40 AM

I am trying to insert a row in an excel spreadsheet and am getting this error message can someone tell me what it means
To prevent loss of data excel cannot shift non blank cells off the worksheet.
Try to delete or clear the cells to the right & below your data then select cell A-1 & save your workboot to reset the last cell used.


Posted by Bruce on September 14, 2001 11:09 AM

Press Ctrl + End Key to see where the end of your data is. Do you have data in row 65536? Try to delete some row where you have no data an then try to insert as new row.

Posted by Sunny on September 14, 2001 11:45 AM

Thank you, I did have something in the last row :)