Unable to unhide hidden columns

  • Thread starter Thread starter MichaelRLanier
  • Start date Start date
M

MichaelRLanier

I have an important file that in times past I've been able to hide and
unhide rows and columns as needed. Now, a number of worksheets will
suddenly no longer unhide. Is there a way to force hidden columns to
be unhidden, but will not prevent them from being hidden later?
Thanks for any help.

Michael
 
If you hid them using a macro with xlveryhidden they can only be unhidden by
code.
Else, goto the cells cell(above the 1 and to the left of the A
titles)>format>rows>unhide
OR, row height??? set to 0
 
Maybe you unhide them, but have the windows frozen so you can't scroll to see
them.

In xl2003 menus, I'd use:
window|unfreeze panes
then scroll up/to the left

(after you've unhidden the rows/columns)
 
If say column D is hidden because it has been made to zero width, use Go to
and go to D1. You can then resize.
Gus
 
Back
Top