Thread: change Excel column headings from numbers to alpha characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default change Excel column headings from numbers to alpha characters
Tools|Options|General Tab|Uncheck R1C1 Reference Style.

Changing Excel Column Headings wrote:

My Excel spreadsheet has numbers in the column headings. I can't find a way
to change them back to alpha characters.

--

Dave Peterson
Reply With QuoteReply With Quote