Column designations (A, B, C,..) are now numbers-how do I change

G

Guest

For my column headings that are normally A, B, C, etc. somehow they have
changed to 1, 2, 3, etc. They are now the same as my row designations.
How do I change them back?
Thanks
 
S

schall

In the tools menu, select Options. In the Options dialogue box, click on
the General tab at the top. Uncheck the box next to R1C1 reference
style.

Click okay, and you should be good to go.
 

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

Column grid headings 2
Importing numbers from 200 worksheets into 1 4
Change the column designation from a numeric to an alpha 2
My column headings somehow changed from letters to numbers...help 1
column changed to numbers 2
how do I change the default name of a column from numbers to lett. 4
My Excel columns are now denoted with numbers not letters, why? 1
Column headings - urgent help needed please 3

Top