the name of my columns in excel

B

BEBE_CABRERA

the name of my columns in excel changed from A, B, C.. to 1, 2, 3...
now because of that it is difficult for me to read my formulas... how do I
change the name of the columns back to A, B, C, D,.....???
 
N

Niek Otten

Tools>Options>General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| the name of my columns in excel changed from A, B, C.. to 1, 2, 3...
| now because of that it is difficult for me to read my formulas... how do I
| change the name of the columns back to A, B, C, D,.....???
 
K

Ken Johnson

the name of my columns in excel changed from A, B, C.. to 1, 2, 3...
now because of that it is difficult for me to read my formulas... how do I
change the name of the columns back to A, B, C, D,.....???
Click to expand...

Tools|Options|General|Settings...deselect R1C1 reference style

Ken Johnson
 
T

Tyro

Somehow you have turned on R1C1 reference style. In Excel 2007 to turn it
off: Office Button/Excel Options/Formulas/Working with formulas. Uncheck
R1C1 reference style. In previous versions of Excel this will be under
Tools/Options. But I'm not sure just where.

Tyro
 
Top