I
Ian Hunt
I have just changed laptops and now excel shows its cell references as R1C1
for cell A1 how do i make it use letters for collumns?
for cell A1 how do i make it use letters for collumns?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How can I make the collumn headers in excel be letters rather tha.
B
Bernardo Lozano
Tools -> Options -> General and uncheck the R1C1 display
J
Jason Morin
Go to Tools > Options. General Tab. Uncheck the box that
reads "R1C1 reference style".
HTH
Jason
Atlanta, GA
reads "R1C1 reference style".
HTH
Jason
Atlanta, GA
P
Peo Sjoblom
Tools>options>general and uncheck R1C1 reference style
C
ChristinaC
Hi Ian,
Go into Tools, Options and the General Tab. In there untick the R1C1
reference style. This should then solve your problem.
Chris
Go into Tools, Options and the General Tab. In there untick the R1C1
reference style. This should then solve your problem.
Chris