"cannot shift objects off sheet" error message,

M

mathewsd001

I can't insert rows, I always get the above message. I also can't cut and
insert a row.
 
F

FSt1

hi,
You have a used space problem. xl thinks you have data either in the far
right column or far bottom row. Select all columns right of your data and hit
the delete key. then select all rows below your data and hit the delete key.
that should do it.

regards
FSt1
 
G

Gord Dibben

Make sure you save after the deleting of rows and columns or Excel won't adjust
the used range.

In older versions you have to save then close and reopen to see changes.


Gord Dibben MS Excel MVP
 
Top