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

  • Thread starter Thread starter Thai
  • Start date Start date
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?
 
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 Headings (Excel 2007) 2
Change Excel Column Headings from A,B etc to names? 2
Row & Column Headings 2
column heading label 1
Consistent Sheet column header rows 2
In Excel, how do I change the titles of the cells from A,B,C etc? 10
Defining a table 5
Parts for my new build 10

Back
Top