unhide columns in Excel

[rmill]

Can I unhide all the hidden columns in a SS at once rather than one column at a time?

 

[pete1001]

Simple I think.

Select all (CTRL A);
Right click any column header and click 'Unhide'
Should do the trick

 

[Zathras]

Yes. Select all with Ctrl-A (or click in the square above the row numbers and left of the column letters) and select Format/Column/Unhide from the menu.

 

[rmill]

if I have 70 columns I don't want to do each column..can I unhide the whole SS with one click somehow?

 

[mbarron]

Here is a marco that will do the same as what Pete and Zathra have posted. I recorded (Tools/Macro Record New Marco) the macro using the method Pete posted.


Sub unhide_all()
Cells.Select
Selection.EntireColumn.Hidden = False
End Sub


You can then assign the macro to a button. Mike