View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Worksheet has numeric column headings. Change to alpha headings?

Hi Frank,

Office button (large round top left)Excel OptionsFormulas tab, Uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Be Frank" wrote in message ...
|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