Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel "cannot shift objects off sheet" Error


(!)

dhayes1963's Avatar
dhayes1963 dhayes1963 is offline
Member with 64 posts.
THREAD STARTER
 
Join Date: May 2002
Location: Melbourne, Australia
Experience: Intermediate
26-Jan-2006, 02:32 AM #1
Excel "cannot shift objects off sheet" Error
I am trying to hide or delete some columns in an Excel Spreadsheet (using Excel 2003). Often I cannot perform these functions because I get the "error cannot shift objects off sheet". I understand that this is usually associated with Comments in a cell in the column or adjacent columns. I have followed an MS Knowledgebase article and still can't resolve the problem. It also affects a heap of adjacent columns with no comments in them. Any ideas as to what I can do to hide or delete the columns ?
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
26-Jan-2006, 04:57 AM #2
I don't know about comments, but this is usually down to "stray" data (i.e "right-most" columns or "bottom-most" rows).

Press CTRL+End, where the cursor goes to is the extent of your used columns/rows -- at least as far as Excel "thinks".

In essence, deleting any unrequired columns and/or rows and then saving should reset the used space.
dhayes1963's Avatar
dhayes1963 dhayes1963 is offline
Member with 64 posts.
THREAD STARTER
 
Join Date: May 2002
Location: Melbourne, Australia
Experience: Intermediate
26-Jan-2006, 05:10 AM #3
Thanks Bomb #21. I deleted some blank rows at the base of the file, and now I am able to delete and hide columns. No error messages. Much obliged.
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
26-Jan-2006, 05:12 AM #4
-- have a good one.
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
26-Jan-2006, 10:02 AM #5
Don't forget to mark your thread as Solved, you can do so by going to Thread Tools | Mark Solved | Perform Action.
glbcpa's Avatar
glbcpa glbcpa is offline
Computer Specs
Junior Member with 17 posts.
 
Join Date: Oct 2007
Location: Dallas, TX
Experience: Intermediate
22-Aug-2008, 11:48 AM #6
I just found this post, tried these suggestions and they did not work.

However, I did figure out that ALL ROWS & COLUMNS need to be "un-hidden" before attempting to track down this error. After unhiding, no longer received error messages when trying to hide a couple rows.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2