hiding columns, error message says cannot shift objects off sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Thanks for the advice - it seems to be the best suggestion received to date.

Appreciate the assistance!

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
 
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...
 
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...
 
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...
 
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...
 
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...
 
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...
 
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!
 
Just for the next time <bg>.

Edit|goto|Special
Comments

It might help you tab between cells with comments.
 
Hiding columns on a spreadsheet ( which we do frequently)
says: 'cannot shift objects off spreadsheet'
WHat does this mean and how do I work around it?
 
i have shortened the lenght and breadth of the miscrosoft excel sheet and now when i am opening the file ,it's showing me that "cannot shift objects off sheet"
what is the meaning of this and what steps are required by me to take care of the file further
 

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

Similar Threads

Cannot shift objects off sheet? 2
"cannot shift objects off sheet" error 8
Getting error message when trying to hide a column 2
Error Message: "Cannot shift objects off sheet." 1
Hiding Columns 2
How to hide more columns 3
Try to hide column - message "can not shift objects off sheet 1
Cannot Shift Object off Sheet 1

Back
Top