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
 
Ad

Advertisements

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

Top