Excel shows numbered column headers.
 

My spreadsheet shows numbered row headers and numbered column headers. I
want to change the column headers to letters but do not know how. Need help
please. Thanks.

Excel shows numbered column headers.
 

hi
on the menu bar...
Toolsoptionsgeneral tabuncheck R1C1 reference style

Regards
FSt1

"Mike Blum" wrote:

My spreadsheet shows numbered row headers and numbered column headers. I
want to change the column headers to letters but do not know how. Need help
please. Thanks.

Excel shows numbered column headers.
 

Excel 2003 and earlier.

ToolsOptionsGeneral. Uncheck "R1C1 Reference Style"


Gord Dibben MS Excel MVP

On Wed, 10 Oct 2007 17:21:02 -0700, Mike Blum
wrote:

My spreadsheet shows numbered row headers and numbered column headers. I
want to change the column headers to letters but do not know how. Need help
please. Thanks.

Excel shows numbered column headers.
 

That did the trick. Thank you very much for your help.

"FSt1" wrote:

hi
on the menu bar...
Toolsoptionsgeneral tabuncheck R1C1 reference style

Regards
FSt1

"Mike Blum" wrote:

My spreadsheet shows numbered row headers and numbered column headers. I
want to change the column headers to letters but do not know how. Need help
please. Thanks.

Excel shows numbered column headers.
 

Thank you very much for the help. Mike

"Gord Dibben" wrote:

Excel 2003 and earlier.

ToolsOptionsGeneral. Uncheck "R1C1 Reference Style"


Gord Dibben MS Excel MVP

On Wed, 10 Oct 2007 17:21:02 -0700, Mike Blum
wrote:

My spreadsheet shows numbered row headers and numbered column headers. I
want to change the column headers to letters but do not know how. Need help
please. Thanks.