Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

And for objects that may not be displayed:
xl2003:
tools|options|view tab|Check Show All

xl2007:
Office button|excel options|advanced
Display options for this workbook|For objects|Show|check all

ctrl-6
Should do the same in any version.


Debra Dalgleish has a blog post, too:
http://blog.contextures.com/archives...in-excel-2007/

SnareHiHat wrote:

I have a file in which I am trying to hide some data columns. I can do this
successfully across c.30 coulmns and then when I try to hide more or redraw
the column width, I get an error response "Cannot shift objects off sheet". I
have managed to hide all the columns in another file which has exactly the
same number of columns. What trick am I missing?

--

Dave Peterson