Excel columns and rows are both numbered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Excel columns are now numbered instead of being alphabetical so what was
A1 is now R1C1. How do I return to alphabetically labeled columns? Thanks
 
This is an Access newsgroup, and your question would be better asked in an
Excel newsgroup. However, it's a slow night, so now that you're here ...

Select Options from the Tools menu, select the General tab, and uncheck the
"R1C1 reference style" check box.
 
Thanks Brendan, that did the trick.


Brendan Reynolds said:
This is an Access newsgroup, and your question would be better asked in an
Excel newsgroup. However, it's a slow night, so now that you're here ...

Select Options from the Tools menu, select the General tab, and uncheck the
"R1C1 reference style" check box.
Click to expand...
 
You must log in or register to reply here.

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

How: reset the column headings from numeric to alphabetic? 1
How can I change the column order using VBA 5
Can I change the column heading from alphabetic to numeric? 2
how to mention rows in alphetical format instea dof numbers 2
how do I sort a file based on one columns info without mixing up 2
Why are my column headings numerical instead of alphabetical? 1
Cells display as R5C5. How do I change it to display E5? 2
Column headers numbers instead of letters 2

Back
Top