"Cannot shift objects off sheet" when grouping or hiding

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.
 
J

Jan Karel Pieterse

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.

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

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
G

Guest

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
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.
 

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