Column header format

[b_wildman]

How can I change the column headers from numbers to letters? Instead of rows
labeled as numbers and columns as letters, they are both numbers. EXCEL 2003.

Thanks for the help.

 

[Pete_UK]

Click on Tools | Options | General tab and unclick R1C1 Reference
Style, then OK.

Hope this helps.

Pete

 

[John C]

Go to menu Tools|Options, General tab, uncheck R1C1 reference styles.

 

[Sheeloo]

Go to Tools > Options. Pick the General Tab. The first box in the settings
section will be checked ("R1C1 reference style"). Uncheck this box. Click OK.
Your problem should be solved.

 

[Lynn]

Hi John -- any advice on how to change the column labels back to letter in
Excel 2007? I can't find the Tools/Options, general Tab you referenced below
for Excel 2003. Any advice would be appreciated!

Lynn

 

[T. Valko]

In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK