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

T

Thai

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?
 
N

Niek Otten

Tools>Options>General tab>Uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column heading label 1
Parts for my new build 10
Column Headings (Excel 2007) 2
Row & Column Headings 2
Xiaomi Redmi Note 10 Pro?? Do or die? 11
How do I make the heading cells always display? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Include text as part of Heading style 3

Top