Columns are numbers instead of letters

M

Mike

Excel 03, how do you change the columns from numbers to letters. Both the
column and rows are setup as numbers, instead of the rows being numbers and
the columns being letters.
 
B

Bernard Liengme

Tools / Options/ General tab; in the Setting area (near top) there is a box
"R1C1 Reference style"
When this is checked, column have numbers, when unchecked column have
letters
best wishes
 
J

jlclyde

Excel 03, how do you change the columns from numbers to letters.  Both the
column and rows are setup as numbers, instead of the rows being numbers and
the columns being letters.  
Click to expand...

Tools/Options/general/R1C1 uncheck
Jay
 

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 header format 5
Columns now numbers rather than letters how do i get letters back 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Excel sheet with numbers as column & row headers - How? 3
Cells display as R5C5. How do I change it to display E5? 2
I'd like to name columns, instead of A, B, C, D, etc. 1
column headers changed from letters to numbers, how do I change ba 1
Why are column headings numbers instead of letters? 1

Top