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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

suddenly can't add row 2
Shifting cells to the right 0
can't add row exsisting sheet 2
Merging from an Excel file with graphics 1
Can't insert columns 1
Why am I not able to insert a row in my worksheet? 3
Error Message 0
I can't insert column in Excell file! Help please 2

Top