Switching view on/off for row & column headers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you make the row and column headers( ie: A ~Z and 1~100000) viewable /
not-viewable?
 
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
 
Back
Top