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

Setting column width in a table with a macro is not working 0
Columns now numbers rather than letters how do i get letters back 2
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Problem with SET & REF function 0
Help With Typing Russian Letters On Microsoft Word Mac 0
VBA - exporting serial letters to single documents 0
Column header format 5
Modern equivalent of Autotext in Word? 0

Top