| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Switching view on/off for row & column headers?
How do you make the row and column headers( ie: A ~Z and 1~100000) viewable /
not-viewable? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Switching view on/off for row & column headers?
try,
Tools|Options|View Un-Check row & column headers. Mike "J@Y" wrote: How do you make the row and column headers( ie: A ~Z and 1~100000) viewable / not-viewable? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Switching view on/off for row & column headers?
Thanks very much!
"Mike H" wrote: try, Tools|Options|View Un-Check row & column headers. Mike "J@Y" wrote: How do you make the row and column headers( ie: A ~Z and 1~100000) viewable / not-viewable? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Switching view on/off for row & column headers?
ToolsOptionsView. Uncheck "row and column headers"
Or a macro to toggle off/on Sub Toggle_Headers() With ActiveWindow .DisplayHeadings = Not .DisplayHeadings End With End Sub Gord Dibben MS Excel MVP On Wed, 18 Jul 2007 13:08:04 -0700, J@Y wrote: How do you make the row and column headers( ie: A ~Z and 1~100000) viewable / not-viewable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make column values column headers | Excel Discussion (Misc queries) | |||
| column is hidden in normal view but not print view | Excel Worksheet Functions | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| Viewing footers and headers in normal view | Excel Discussion (Misc queries) | |||
| View row headers while scrolling | Excel Discussion (Misc queries) | |||
Linear Mode
