| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
hiding columns, error message says cannot shift objects off sheet
"JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
|
#2
|
|||
|
|||
|
"JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
|
#3
|
|||
|
|||
|
"JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
|
#4
|
|||
|
|||
|
"JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
|
#5
|
|||
|
|||
|
"JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
|
#6
|
|||
|
|||
|
"JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
|
#7
|
|||
|
|||
|
I am having the same problem and have tried every solution on this page. It
still will not let me hide all of the columns I need to hide. The file in question uses through column HK and a large amount of columns (around 60) need to be hidden. Anyone have an answer? Thank you! "JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
|
#8
|
|||
|
|||
|
The thread has aged off for me, but is this the stuff you tried:
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. Elily00 wrote: I am having the same problem and have tried every solution on this page. It still will not let me hide all of the columns I need to hide. The file in question uses through column HK and a large amount of columns (around 60) need to be hidden. Anyone have an answer? Thank you! "JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! -- Dave Peterson |
|
#9
|
|||
|
|||
|
Dave,
Thank you. I got rid of my comments (not easy) and that cured it. "Dave Peterson" wrote: The thread has aged off for me, but is this the stuff you tried: 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. Elily00 wrote: I am having the same problem and have tried every solution on this page. It still will not let me hide all of the columns I need to hide. The file in question uses through column HK and a large amount of columns (around 60) need to be hidden. Anyone have an answer? Thank you! "JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! -- Dave Peterson |
|
#10
|
|||
|
|||
|
Just for the next time <bg.
Edit|goto|Special Comments It might help you tab between cells with comments. Paul H. J. wrote: Dave, Thank you. I got rid of my comments (not easy) and that cured it. "Dave Peterson" wrote: The thread has aged off for me, but is this the stuff you tried: 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. Elily00 wrote: I am having the same problem and have tried every solution on this page. It still will not let me hide all of the columns I need to hide. The file in question uses through column HK and a large amount of columns (around 60) need to be hidden. Anyone have an answer? Thank you! "JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding columns, error message says cannot shift objects off sh
This problem was really getting to me but this article sorts it all out
http://office.microsoft.com/en-us/ex...412411033.aspx As a quick fix, try CTRL+6 Cheers Jesper |
|
#12
|
|||
|
|||
|
Which page would that be?
Gord Dibben Excel MVP On Thu, 28 Jul 2005 12:56:15 -0700, "Elily00" wrote: I am having the same problem and have tried every solution on this page. It still will not let me hide all of the columns I need to hide. The file in question uses through column HK and a large amount of columns (around 60) need to be hidden. Anyone have an answer? Thank you! "JeannieNewman" wrote: Hiding columns on a spreadsheet ( which we do frequently). Error message says: 'cannot shift objects off spreadsheet'. WHat does this mean and how do I work around it? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Columns | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| hiding columns automatically | Excel Discussion (Misc queries) | |||
| hiding columns automatically | Excel Discussion (Misc queries) | |||
| Hiding columns based on user/password | Excel Worksheet Functions | |||
Hybrid Mode
