ExcelBanter - How do I change the column heading in Excel to display "A" "B" "C

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I change the column heading in Excel to display "A" "B" "C (https://www.excelbanter.com/new-users-excel/168041-how-do-i-change-column-heading-excel-display-b-c.html)

Thai

How do I change the column heading in Excel to display "A" "B" "C

I have Excel 2003 and when I start is up, the new worksheet display the
column heading as "1" "2" "3" etc. How do I change it to A, B, C etc?

Niek Otten

How do I change the column heading in Excel to display "A" "B" "C

ToolsOptionsGeneral tabUncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Thai" wrote in message ...
|I have Excel 2003 and when I start is up, the new worksheet display the
| column heading as "1" "2" "3" etc. How do I change it to A, B, C etc?

All times are GMT +1. The time now is 07:30 AM.