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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
column labels 2
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3
Column headers numbers instead of letters 2
How to change column labels back to letters? 1
How do I change column labels from numbers to letters? 2
How to change numbered columns to letters? 3
how do I change column headers from a number to a letter 2

Back
Top