hidden column

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi everybody,

I'm trying to unhide hidden columns and for all
spreadsheets in some workbook I could do it. But, just for
one spreadsheet it begins with only B column - I cannot
unhide A column.
I'm pressing the button on left top corner of a
spreadsheet and go to Format->Column->Unhide and it's
working for 100 spreadsheets in this workbook except one.
Could anybody advise anything else?
Thanks advance.
 
Alex

It's hard to grab column A. You can unhide all the columns
in a sheet with this macro if you don't mind using VB.

Sub unhide()
With ActiveSheet
.Columns.Hidden = False
End With
End Sub

To run a macro press ALT + F11 to open the VB editor.
Choose, Insert, Module then copy the macro into the module
and press F5 or choose run on the Tool Bar.

I've just though that you could probably select several
sheets at once and it should do them all.

Regards
Peter
 
hi alex

what you need to do is click to the left of column A and
above Row 1 to select all columns and rows and then go
Format, Column and then Unhide

should do the trick
 
Maybe the problem is that the column isn't hidden, but that the width is set
to 0.
To solve that press F5 ( goto) and enter A1, then Format; column; width; any
value > 0

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Your welcome Alex

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top