Worksheet has numeric column headings. Change to alpha headings?

B

Be Frank

I received a Excel SS via e-mail from a trusted source. I brought it up in
Excel 2007. This SS has numeric column headings and the cell locations are
defined in this confusing format also. How do I change the column headings
back to alpha characters? Thanks

Be Frank
 
N

Niek Otten

Hi Frank,

Office button (large round top left)>Excel Options>Formulas tab, Uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I received a Excel SS via e-mail from a trusted source. I brought it up in
| Excel 2007. This SS has numeric column headings and the cell locations are
| defined in this confusing format also. How do I change the column headings
| back to alpha characters? Thanks
|
| Be Frank
| --
| Bye Now
 

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

How: reset the column headings from numeric to alphabetic? 1
Column Headings Numeric 4
Excel Column Headings Numeric to Alpha 1
Change worksheet column headings from numbers to letters 2
Column headings numerical not alpha 1
change column heading names from numbers to alpha characters 3
Column Headings 1
How do I change excel column heading from numeric to alphabetic? 3

Top