Unable to unhide hidden columns

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
 
D

Don Guillett

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
 
D

Dave Peterson

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)
 
G

Gus

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
 

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