How to unhide all?

  • Thread starter Thread starter Sherees
  • Start date Start date
S

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.
 
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.
 
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!
 
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
 
Back
Top