Thread: What's hidden?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default What's hidden?

There's no way to just unhide a column header.
However, you can enter the header names in a list in an out-of-the-way
location, say AA1 to AA5:
C - Gross
D - Tare
E - Net
.... etc.

Then, select those 5 cells and click in the name box.
Type a short name, say
List
Then hit <Enter.

Now, to remind yourself, click in the name box, and click on "List",
And you'll see your header names.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Michael Horowitz" wrote in message
...
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