Any Answers (back to index)
Excel 2007 Error message
Posted by Anonymous on Thu, 04/02/2010 - 12:37
I have never came across the following error message on previous excel versions, but I have now in excel 2007.The error is: “Cannot shift objects off sheet”.I am simply trying to insert a new column between two existing columns. I have figures in Columns “A” and “B”. As far as I know, I do not have any objects on my spreadsheet. To overcome the error, I just highlight the whole columns and shifted them in order to insert a new column. I am sure this is easy for some excel users, but I cannot work out. Thanks for you help!
- 516 reads
- login or register to post comments
- Add to a social bookmarking site
Latest questions on 
.
Hi
Check the following knowledge base article on Microsoft's website (it includes ways to deal with this error):
http://support.microsoft.com/kb/211769
Richard
Cannot shift objects off sheet
You have reached the limit of number of columns allowed.
To add more columns, you have to delete some columns.
Excel 2007 Error message
Hi Richard,
I followed the instractions on the MS wsite link and it now works.
Thanks for your help.