How do I change column label from number to letter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Usually, the rows are numbers and the colums letters. Right now, my columns
are numbers also. How can I get it fixed because this is really confusing for
formulas.
Thank you.
 
Tools > Options > GeneralTab..........uncheck the R1C1 reference style
box.............

Vaya con Dios,
Chuck, CABGx3
 
Hello Adel,

On the Excel Toolbar select: Tools | Options | General (tab) | Settings
| R1C1 Reference Style (check box)

Click the Check Box. The Check Mark will disappear. Click OK and your
Columns will display letters again instead of numbers.

Sincerely,
Leith Ross
 
Hi Adel. Go to Tools - Options and on the General Tab, deselect "R1C1"
reference style. HTH
 
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
Why does my Excel shows the rows and the columns as numbers? 4
how do I change column headers from a number to a letter 2
how do I change cell labelling from R1C1 to A1? 2
Columns are numbers instead of letters 4
Column header format 5

Back
Top