How do I hide or unhide row and column heading in Excel?

G

Gord Dibben

Tools>Options>View

Uncheck whatever you don't want to see.

If you want to be able to toggle off/on assign this macro to a button or
shortcut key.

Sub Toggle_Headings()
With ActiveWindow
.DisplayHeadings = Not .DisplayHeadings
End With
End Sub



Gord Dibben MS Excel MVP
 
Top