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

Advertisements

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

Advertisements

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

Top