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

[Maharaj]

[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

On Tue, 25 Jul 2006 07:35:02 -0700, Maharaj <[email protected]>
wrote: