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

  • Thread starter Thread starter Peter
  • Start date Start date
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
 
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
 
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
Click to expand...

Hi Peter

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

Edward
 
Back
Top