hiding columns, error message says cannot shift objects off sheet

J

JeannieNewman

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

Guest

hi,
excel thinks that there is data in column IV. excel by
default cannot shift data off the sheet ie beyound column
IV or below row 65536.
solution. highlight all the column to the right of your
data and hit the delete key. that should fix it.
 
J

JeannieNewman

Thanks for the advice - it seems to be the best suggestion received to date.

Appreciate the assistance!

JeannieNewman
 
J

JeannieNewman

Thanks Gord - I'll look back to see if the previous user left any "comments"
that I was not aware of.

Appreciate the help.

JeannieNewman
 
J

JORGE ORTIZ

JeannieNewman said:
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!
Click to expand...
 
J

JORGE ORTIZ

JeannieNewman said:
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!
Click to expand...
 
J

JORGE ORTIZ

JeannieNewman said:
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!
Click to expand...
 
J

JORGE ORTIZ

JeannieNewman said:
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!
Click to expand...
 
J

JORGE ORTIZ

JeannieNewman said:
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!
Click to expand...
 
J

JORGE ORTIZ

JeannieNewman said:
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!
Click to expand...
 
E

Elily00

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

Dave Peterson

Just for the next time <bg>.

Edit|goto|Special
Comments

It might help you tab between cells with comments.
 
Top