Hiding Columns

[SnareHiHat]

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?

 

[FSt1]

hi
odd error to get in this situation. usually the error appears when trying to
add columns or rows. the problem is usually because excel has lost it
reference to used range.
see this site. it may help.
http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

 

[Dave Peterson]

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?scid=kb;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/2009/03/16/cannot-shift-objects-off-sheet-in-excel-2007/