change excel auto column headers from numeric to alpha

Across the top of the Excel spreadsheet there are usually letters, ie., A,B,C
to head the columns. My Excel has numbers and I want to change them to the
usual letters. How do I do this?

Tools|options|General tab|Uncheck R1C1 Reference style

MarcieinHawaii wrote:
>
> Across the top of the Excel spreadsheet there are usually letters, ie., A,B,C
> to head the columns. My Excel has numbers and I want to change them to the
> usual letters. How do I do this?

--

Dave Peterson

Tools > Options > General > R1C1 > Uncheck

HTH
Regards,
Howard

"MarcieinHawaii" <MarcieinHawaii@discussions.microsoft.com> wrote in message
news:6800B725-BA23-4F26-9CAD-CC162964016A@microsoft.com...
> Across the top of the Excel spreadsheet there are usually letters, ie.,
> A,B,C
> to head the columns. My Excel has numbers and I want to change them to
> the
> usual letters. How do I do this?