column labels

D

Djolexyz

My column labels start apearing as numbers instead of letters A, B, C...
I want letters back as formulae are easier to read with A,B,C rather than
R[-2] etc
 
B

Bernard Liengme

In XL 20003 (an before): Tools / Options / General tab / uncheck first item
"R1C1 reference style"

In XL 2007: Office / Excel options / Formulas tab / Working with Formulas
(second group), uncheck first item "R1C1 reference style"

best wishes
 
D

Djolexyz

Perfect! Thanks a lot.

Bernard Liengme said:
In XL 20003 (an before): Tools / Options / General tab / uncheck first item
"R1C1 reference style"

In XL 2007: Office / Excel options / Formulas tab / Working with Formulas
(second group), uncheck first item "R1C1 reference style"

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Djolexyz said:
My column labels start apearing as numbers instead of letters A, B, C...
I want letters back as formulae are easier to read with A,B,C rather than
R[-2] etc
Click to expand...
Click to expand...
 

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

Row & Column Headings 2
In Excel I now have numbers instead of letters on column tops 1
Sort 1 column and another changes 2
Column headings - urgent help needed please 3
Column Labels 1
Top Row on Excel has changed to 1, 2, 3... in lieu of A, B, C? 1
Excel Convert word into numbers and back 4
Formulae needed 1

Top