Column numbers to letters

  • Thread starter Thread starter Martha
  • Start date Start date
M

Martha

In excel, how can I change the column titles from numbers
back to the usual letter?
 
Here is the info/fix:
The R1C1 reference style

You can use a reference style where both the rows and the
columns on the worksheet are numbered. The R1C1 reference
style is useful for computing row and column positions in
macros. In the R1C1 style, Excel indicates the location of
a cell with an "R" followed by a row number and a "C"
followed by a column number.

To turn R1C1 reference style on or off
Click Options on the Tools menu, and then click the
General tab.

Under Settings, select or clear the R1C1 reference style
check box.
 
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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns now numbers rather than letters how do i get letters back 2
Creating sequential numbers plus a letter 4
Excel Column labels show as numbers 2
Columns are numbers instead of letters 4
Excel 2007... fix column headings from numbers back to letters 4
How to change numbered columns to letters? 3
Colunmn headers 4

Back
Top