ExcelBanter - Switching view on/off for row & column headers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Switching view on/off for row & column headers? (https://www.excelbanter.com/excel-discussion-misc-queries/150772-switching-view-off-row-column-headers.html)

J@Y

Switching view on/off for row & column headers?

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

Mike H

Switching view on/off for row & column headers?

try,

Tools|Options|View

Un-Check row & column headers.

Mike

"J@Y" wrote:

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

J@Y

Switching view on/off for row & column headers?

Thanks very much!

"Mike H" wrote:

try,

Tools|Options|View

Un-Check row & column headers.

Mike

"J@Y" wrote:

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

Gord Dibben

Switching view on/off for row & column headers?

ToolsOptionsView. 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

On Wed, 18 Jul 2007 13:08:04 -0700, J@Y wrote:

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

All times are GMT +1. The time now is 05:28 AM.