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!

"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!

"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!

"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!

"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!

"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!

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!

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

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!

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

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

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