R1C1

G

Guest

How do you change the cell reference style from "normal" to R1C1 in Excel? I
cannot remeber where? Thanks alot!
 
B

Bob Phillips

Tools>Options>General, R1C1 reference style
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

r1c1 reference style - how to make it default 4
How do I get Excel column headings to be letters not numbers? 3
R1C1 reference 1
R1C1 Reference Style won't STAY gone? 5
Column headers numbers instead of letters 2
R1C1 reference style as default while opening Excel 3
Column headings display as a numbers 7
Excel 2007 Reference Style 1

Top