Setting column labels to letters

G

Gene Goldenfeld

I just noticed that my worksheet column labels (across the top) are numbers
instead of letters. Don't think it's always been that way, but I want to
change it now and haven't found anything yet in Tools or Help that
references it. Would someone please point the way. thanks,

Gene Goldenfeld
 
C

Chip Pearson

Gene,

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
G

Gene Goldenfeld

Chip said:
Gene,

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.
Click to expand...

Thanks, Chip. I had tried that previously but was blocked by a Name Change
box, even when in a blank cell. It seems that this change has to be made
in a blank worksheet.

Gene
 
Top