How do I change Excel column cell identifiers back to letters?

C

cotmc

While merging data from different worksheets and formatting cells, I suddenly
noticed the column identifiers at the top of my worksheet changed to numbers
instead of letters. Any good ideas on how I should change them back to
letters? I searched Help Online and came up empty thus far. Thanks!
 
L

Leith Ross

Hello Cotmc,

On the the menu go to Tools>Options>General>Settings and click the box
marked R1C1 style to clear it.

Sincerely,
Leith Ross
 
R

Ron Coderre

Try this:

Tools>Options>General tab
UNcheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
C

cotmc

Yes! Thanks a million!

Ron Coderre said:
Try this:

Tools>Options>General tab
UNcheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
Top