Worksheet has numeric column headings. Change to alpha headings?

  • Thread starter Thread starter Be Frank
  • Start date Start date
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
 
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
 
Back
Top