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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle Roach - 23 May 2008 07:18 GMT

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?

Reply to this Message

Mike H - 23 May 2008 09:41 GMT

Hi,

Have a look here

http://www.nickhodge.co.uk/tipstrick.htm

Mike

> 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
[quoted text clipped - 7 lines]
> filters or have I tried to hide or unhide anything. UUURGH! Any clever people
> have any suggestions?

Reply to this Message

Jon Peltier - 23 May 2008 17:51 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> When I try and insert either a row or column into a my spread sheet the
> above
[quoted text clipped - 12 lines]
> people
> have any suggestions?

Reply to this Message