change column heading names from numbers to alpha characters

  • Thread starter Changing Excel Column Headings
  • Start date
C

Changing Excel Column Headings

Currently my Excel spreadsheets show numbers fort the column headings. I
want to go back to alpha characters (a, B, C, etc.); but, I can't find a way
to change the headings. Please help!!
 
D

Dave Peterson

Check one of your other posts.
Currently my Excel spreadsheets show numbers fort the column headings. I
want to go back to alpha characters (a, B, C, etc.); but, I can't find a way
to change the headings. Please help!!
Click to expand...
 
B

Bob Phillips

Tools>Options>General and uncheck R1C1 Reference Style

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Changing Excel Column Headings"
 
Top