How do I change column label from number to letter?

A

adel

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.
 
C

CLR

Tools > Options > GeneralTab..........uncheck the R1C1 reference style
box.............

Vaya con Dios,
Chuck, CABGx3
 
L

Leith Ross

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
 
M

Michael

Hi Adel. Go to Tools - Options and on the General Tab, deselect "R1C1"
reference style. HTH
 
Top