Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Hidden data - hidden chart | Charts and Charting in Excel |