Switching view on/off for row & column headers?

[J@Y]

How do you make the row and column headers( ie: A ~Z and 1~100000) viewable /
not-viewable?

 

[Mike H]

try,

Tools|Options|View

Un-Check row & column headers.

Mike

 

[J@Y]

Thanks very much!

try,

Tools|Options|View

Un-Check row & column headers.

Mike

 

[Gord Dibben]

Tools>Options>View. 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