Setting column labels to letters

  • Thread starter Thread starter Gene Goldenfeld
  • Start date Start date
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
 
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
 
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
 
Back
Top