to prevent possible loss of data, excel cannot shift nonblank cells off the worksheet.

When I go to insert cells I often get an error message saying:

 "to prevent possible loss of data, excel cannot shift nonblank cells off the worksheet. Select another location in which to insert new cells or delete data from the end of your worksheet."

I am using 2010. When I was using 2003 this never happened.

If I select End/Down Delete and then save the workbook it lets me insert the row.

Is there a way to stop this?

Thanks
JagwarmanAsked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
It would appear that you have "something" which excel seems to think is in all cells.

If you go to the end of the data and then highlight the next row down (first blank row).
then [ctrl]+[down]
then [ctrl]+[minus]

This will delete all blank rows (making sure that the rows are blank)
This should stop the behaviour.

If it doesn't, you may need to post a copy of the file for us to diagnose.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.