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
 

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

Similar Threads

Unable to hide columns 1
Hide columns 3
Error message when hiding columns 1
How do I stop copying hidden columns? 2
Shifting Objects 2
Excel EXCEL - using a date dependant formula to hide rows 3
Unable to hide columns 1
Hiding Columns help ! 2

Back
Top