Unable to hide columns

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Hello All,

I have a spreadsheet where on one of the sheets, if I try to hide more than
7 columns at one time, I receive the following message:
'cannot shift objects off sheet'
Can anyone help on this.

Graham
 
I have experienced the same thing.. Always when I try to hide rows.
As to my knowledge there is no solution. It is a bug in excel tha
happens when you have hidden rows, and delete an visible row just abov
the hidden part.
If the hidden part has formatted areas, it wont let you hide that par
again.

I have searched everywhere, but there is no solution except for copyin
the data you have into a new worksheet and continue your work there.

Regards Rune Dau
 
Back
Top