Column Labels change

J

jc132568

Dear Experts,
This is the first time this has ever happened to me. I opened Excel today
and the column headers A,B,C etc are now numbers 1,2,3 etc. Why has this
happened?
kind regards
Martina
 
M

Mike Rogers

jc132568

Tools>options>General tab>Remove check mark from R1C1 reference style

Mike Rogers
 
J

jc132568

Thanks for that ... I found the formulas hard to edit in the R1C1 style.
Thanks for your help.
 

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

Column headings 2
Change color of row and column worksheet headers 2
Column heads are numbers 4
How do I change the labels of my columns from numbers to letters? 1
Column Headers 1
How do I change the column ID in Excel from number to text? 5
Change the properties of the worksheet row or column header bars 6
Having Blank Cells, etc. ? 1

Top