How to unhide all?

[Sherees]

I hide columns from I-IV(end) now i want to go to the column I(unhide all),Do
i need to unhide each column by column(there is a way, i know), Pls tell how
to unhide all in one click.

 

[trip_to_tokyo]

In EXCEL 2007:-

- highlight columns H and IU

- right hand click (once)

- Unhide

All the columns that were previously hidden will now be revealed.

If my comments have helped please hit Yes.

Thanks.

 

[Ms-Exl-Learner]

Take your mouse in the Column header of H and click the H and hold the mouse
button and move it to the right. A small popup nearby the Column will show
249C. Leave the mouse button and do right click in H Column and select
Unhide.

Remember to Click Yes, if this post helps!

 

[Gord Dibben]

Never get it done in one click unless you mean one click on a button to run
a macro.

Ctrl + a(twice in Excel 2003)

Format>Column>Unhide


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Column IV is not the "end" in 2007


Gord Dibben MS Excel MVP