Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Columns
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Columns
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 "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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Columns
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
hiding columns | Excel Discussion (Misc queries) | |||
Hiding Columns | Excel Worksheet Functions | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
Hiding columns | Excel Discussion (Misc queries) |