'Cannot shift objects off sheet' error message (group/outline)

P

Peter

When I try to hide or group columns in an Excel file, I get the warning
message: 'Cannot shift objects off sheet'. Why does this happen? How do I
remove this blocking factor? Thank you,

Peter
 
F

FSt1

hi
i'ver never gotten that message when trying to hide columns only with trying
to add but i do get that message when excel has lost it's used range
reference and thinks i'm am using a lot more space on the sheet than I really
am.
see this site on how to reset the used range. might clear the problem.

http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1
 
E

Eddy

When I try to hide or group columns in an Excel file, I get the warning
message: 'Cannot shift objects off sheet'. Why does this happen? How do I
remove this blocking factor? Thank you,

Peter

Hi Peter

I am experiencing the same problem, did you find the solution.

Edward
 

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