In MS Excel, how do I change the column ref headers from numbers .

[Guest]

I'm using Excel 2000 v9.0 and the column reference headers have changed to
Numbers (don't know how this happened) - so when I look at a cell reference,
it is now quite confusing as both rows and columns are numbers.

How do I change it back so that column references are letters, as it was
before?

 

[Harald Staff]

Hi

Tools > Options, uncheck R1C1 reference style.

HTH. Best wishes Harald

 

[Gill]

three years later and your post is still helping people! Thanks!