Column headings changed from alphabetical to numerical

G

Guest

For some reason the column headings have changed. What do I have to do to
change them back to alphabetical?
 
B

Bernard Liengme

Tools | Options | open General tab |uncheck R1C1 "reference style"
best wishes
 
G

Guest

Ekmi said:
For some reason the column headings have changed. What do I have to do to
change them back to alphabetical?
Click to expand...

Tools, OPtions, General Tab and click the R1C1 checkbox to remove tick,
click OK

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet columns are displayed numerically instead of alpha 6
How: reset the column headings from numeric to alphabetic? 1
column headings problems 4
Column Heading with black up_down arrows 2
how to change the alphabets to numbers and numbers to alphabets in 2
Column Headings 3
How do I change excel column heading from numeric to alphabetic? 3
Excel How to Auto-Alphabetize a Specific Range in Excel? 1

Top