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

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

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

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.

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