Thread: What's hidden?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Michael Horowitz Michael Horowitz is offline
external usenet poster
 
Posts: 4
Default What's hidden?

Let me restate:
I'm showing coumns A B H I J.
I know C D E F G are hidden, but I don't know their names.
I cannot find the one I'm looking for unless I unhide those columns.
I'm looking for a quick way to remind me what those columns headers
are - Mike


On Tue, 09 Oct 2007 12:50:50 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

The column headers should give you a clue.

A B C E F G would indicate that D is hidden.

To unhide D select C and E and right-clckunhide.

If you had D E F hidden and wanted to unhide just E then click in namebox and
type E1 and Enter then FormatColumnUnhide


Gord Dibben MS Excel MVP

On Tue, 09 Oct 2007 15:03:35 -0400, Michael Horowitz wrote:

I have a spreadsheet with a dozen wide columns.
I have occassion to hide columns so I can fit what I want to see on a
screen. However, sometimes I need to see a hidden column and I don't
recall which one it was. I don't want to have to unhide everything so
I can locate that column.
Is there a trick to seeing the column headings without having to
unhide them? or is there an easy toggle between hide and unhide? -
Mike