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
|