Columns are Numbers

K

kristinm

I have an excel sheet that is listing the Columns as Numbers. How do I
switch this to being letters so the cells are listed as I35 rather than R35C9
 
D

Dave Peterson

In xl2003 menus:

Tools|Options|General tab|Uncheck R1C1 Reference style.

Excel picks up this setting from the first workbook you open in that session.

If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough
to open a workbook that he saved as the first workbook in that session, you'll
be making the same change again.
 
K

kristinm

Thank you. Life is good again.

Dave Peterson said:
In xl2003 menus:

Tools|Options|General tab|Uncheck R1C1 Reference style.

Excel picks up this setting from the first workbook you open in that session.

If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough
to open a workbook that he saved as the first workbook in that session, you'll
be making the same change again.
Click to expand...
 

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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns are numbers instead of letters 4
Columns now numbers rather than letters how do i get letters back 2
Cells display as R5C5. How do I change it to display E5? 2
Excel Column labels show as numbers 2
Column header format 5
Cell References Format 2
Excel sheet with numbers as column & row headers - How? 3

Top