Hide row/column numbers in Excel

[pr24]

Is it possible to hide the row numbers(1,2,3,4...) and the column numbers(A,B,C,D...) in Excel?

 

[xlbo]

Yup - Tools > Options > View
Untick Row and Column Headers

In code :
With ActiveWindow
.DisplayHeadings = False
End With

and a little BTW whilst we're on the subject

With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With

will disable (Hide) Row and Col headers / Horiz and vert scroll bar and tabs

HTH
Geoff

 

[DaleWatson123321]

Tools - Options - View - un-check "Row and column headers"

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca