Columns are numbers instead of letters

  • Thread starter Thread starter Mike
  • Start date Start date
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.
 
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
 
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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Column header format 5
Excel sheet with numbers as column & row headers - How? 3
Column Heading Error 3
Columns now numbers rather than letters how do i get letters back 2
Creating sequential numbers plus a letter 4
reference format and column name 1
Cells display as R5C5. How do I change it to display E5? 2

Back
Top