How can I change column headers from numeric to alpha?

G

Guest

I have a spreadsheet where somehow the column headers got changed from alpha
to numeric. How can I change them back?
 
N

Niek Otten

Tools>Options>General tab, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet where somehow the column headers got changed from alpha
| to numeric. How can I change them back?
 
R

Ron Coderre

From the Excel Main Menu:
<tools><options><general tab>...UNcheck: R1C1 reference style.


Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 

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

Row/Column Headers 2
change column header from numeric to alphac? 6
col gridlines 1
separating alpha numeric vlue 23
Change the column designation from a numeric to an alpha 2
Worksheet has numeric column headings. Change to alpha headings? 1
Column Headings Numeric 4
HOW DO I CHANGE COLUMNS FROM NUMERIC TO ALPHA HEADINGS? 1

Top