how do i change row and column headers to my own text?
 

how?

how do i change row and column headers to my own text?
 

You don't.

Workaround.

Enter titles in row1.

Select A2 and WindowFreeze Panes

ToolsOptionsView. Uncheck row and column headers.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 20:49:02 -0700, jordana456
wrote:

how?

how do i change row and column headers to my own text?
 

For all intents and purposes, you can't.

You can choose to not display the current row and column headers any use
your own *BUT* you'd still have to refer to cells using the standard
headers.

ToolsOptionsViewRow & column headers

--
Biff
Microsoft Excel MVP


"jordana456" wrote in message
...
how?

how do i change row and column headers to my own text?
 

And if you want to enter row headers too, do so in column A, and select B2,
rather than A2, before freezing panes.
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You don't.

Workaround.

Enter titles in row1.

Select A2 and WindowFreeze Panes

ToolsOptionsView. Uncheck row and column headers.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 20:49:02 -0700, jordana456
wrote:

how?