How to unhide all?
 

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.
--
Life isa journey not a destination

How to unhide all?
 

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.


"Sherees" wrote:

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.
--
Life isa journey not a destination

How to unhide all?
 

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!

--------------------
(Ms-Exl-Learner)
--------------------


"Sherees" wrote:

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.
--
Life isa journey not a destination

How to unhide all?
 

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)

FormatColumnUnhide


Gord Dibben MS Excel MVP


On Mon, 21 Dec 2009 00:35:01 -0800, Sherees
wrote:

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.

How to unhide all?
 

Column IV is not the "end" in 2007


Gord Dibben MS Excel MVP

On Mon, 21 Dec 2009 00:44:02 -0800, trip_to_tokyo
wrote:

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.


"Sherees" wrote:

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.
--
Life isa journey not a destination