Error = 'Cannot Shift Objects Off Sheet'


G

Guest

I'm getting this error when trying to hide a number of columns in Excel.
Anyone know why? Thanks!!
 
Ad

Advertisements

A

Alan

MClark said:
I'm getting this error when trying to hide a number of columns in
Excel. Anyone know why? Thanks!!
Most likely cause is that you have comments in cells that are set
*not* to move with the cells or are out to the right in an area that
you would be hiding.

Move the cells comments so that they won't be in the hidden part of
the worksheet after you do the hide operation, and also make sure that
they are set to 'move' with the cells.

HTH,

Alan.
 
G

Guest

Alan,

Is there an Excel function that can make comments 'Move' with the cells or
do i have to manually move them to ensure they're not opening up way to the
right, for example...b/c even by manually moving the comments, I can't seem
to get the columns to collapse & hide...thx again for your help.
 
Ad

Advertisements

A

Alan

MClark said:
Alan,

Is there an Excel function that can make comments 'Move' with the
cells or do i have to manually move them to ensure they're not
opening up way to the right, for example...b/c even by manually
moving the comments, I can't seem to get the columns to collapse &
hide...thx again for your help.
You can select all the comments (Goto - Special - Comments) and change
the properties of them all like that I think.

You would have to do that manually for each sheet unless you tried to
code it in VBA somehow.

HTH,

Alan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top