Insert row/column error "Cannot shift object off sheet"

  • Thread starter Thread starter Michelle Roach
  • Start date Start date
M

Michelle Roach

When I try and insert either a row or column into a my spread sheet the above
error message appears. I have tried pressing CTRL down arrow and CTRL right
arrow to see where excel 'thinks' I have my last data as per recommendations
on other queries and it skips to the very end so obviously that much is true,
however when I proceed to DELETE all rows till the end the error message
still occurs. A quick check with CTRL down arrow confirms that my data 50
lines down is the last information and yet it still won't let me insert.
Furthermore, when I save and reopen again the worksheet defaults back to
believing I have info in the final row and column! I have no comments or
filters or have I tried to hide or unhide anything. UUURGH! Any clever people
have any suggestions?
 
Are you hiding any rows or columns? Are there any shapes on the sheet?
Shapes may get shifted off to the edges of the sheet without affecting the
"last used" row and column. Also look for comments, which are generally
hidden, but often give rise to this warning.

- Jon
 

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 shift objects off sheet 7
Why can't I CONSISTENTLYmove cursor from first column to last colu 2
cannot insert rows -error message "cannot shift object off sheet" 1
Reduce File size 2
Error message "cannot shift nonblank cells off the worksheet" 2
Go to last non-empty cell in column 8
Changing position of last used cell 4

Back
Top