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?