View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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