Why can't I insert a row into an excel sheet.

M

mgm

I am getting a error message: To prevent loss of Data, Excel cannot shift
nonblank cells off the worksheet etc. Never saw this before
 
B

Bob Flanagan

Excel believes you have an entry or comment in the last row or column of
your worksheet. Go the end of your data, select all rows below and deleted.
To the far right of your data and delete all columns to the right. Save,
close and re-open the workbook.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Top