"cannot shift objects off sheet" error message,

G

Guest

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

Guest

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
 

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

"cannot shift objects off sheet" error 8
cannot insert rows -error message "cannot shift object off sheet" 1
Cannot shift objects off sheet 7
cannot shift objects off sheet 1
error message that I can't shift objects off page with insert com 1
Cannot Shift Object off sheet 4
Cannot shift objects off sheet? 2
Can't insert a row 6

Top