how do i unhide columns after saving in excel 2007

P

p-nut

i saved a large spreadsheet after i had hidden columns. I have tried to
unhide on the format and went the the help section. no sulutions were found.
 
G

Geoff_L

Why not try a bit of vba?

Sub Unhide()

For a = 1 To 20 'Or whatever column you need to run to
Columns(a).Hidden = False
Next a

End Sub

Helpful? Click Yes.
 

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