"Cannot shift objects off sheet" when grouping or hiding

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

Guest

When grouping or hiding columns that I've been grouping for a long time, I'm suddenly getting the error "Cannot shift objects off sheet". I can't find a reference to this error in the Excel help, and I can't find any objects in the columns I'm trying to group.

This also happens if I try to hide the entire group of colums, but strangely, I can hide the columns piecemeal.

Please help if you can.
 
Hi Lapplander,
When grouping or hiding columns that I've been grouping for a long time, I'm suddenly getting the error "Cannot shift objects off sheet". I can't find a reference to this error in the Excel help, and I can't find any objects in the columns I'm trying to group.
Click to expand...

Are there any cells with comments within the range to be hidden?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
I was searching the Newsgroup for an answer to this same
question. I am simply trying to hide columns and get the
same error message, "Cannot shift objects off sheet". I
cannot even manipulate the size of the column. Any help
will be appreciated. Using Excel 2000.
-----Original Message-----
When grouping or hiding columns that I've been grouping
Click to expand...
for a long time, I'm suddenly getting the error "Cannot
shift objects off sheet". I can't find a reference to this
error in the Excel help, and I can't find any objects in
the columns I'm trying to group.
This also happens if I try to hide the entire group of
Click to expand...
colums, but strangely, I can hide the columns piecemeal.
 
Back
Top