How to change colum headings back to Letters

[Guest]

 

[Paul B]

Macho, tools, options, general, uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003

 

[Guest]

Don't.

R1C1 is far better than A1.

Relative formulas in A1 change depending on the cell you are on. R1C1
formulas do not change. It makes them easy to validate that a range of
formulas are the same.

Also, when I read these two formulas - "=R[-1]C*0.1" & "=F6*0.1" - I can
immedaitely tell that the first one is looking at the cell immediately above
the current one. The second formula could be pointing to any cell - I need to
know which cell I'm on to know whether it is right. Painful.

Also, how painful is the "A$1" stuff?

James.

 

[Dave Peterson]

I use A1 reference style -- but I do toggle to R1C1 when I'm looking for
inconsistent formulas.

(xl2002 has an option to flag those inconsistent formulas to make it even
easier!)

Don't.

R1C1 is far better than A1.

Relative formulas in A1 change depending on the cell you are on. R1C1
formulas do not change. It makes them easy to validate that a range of
formulas are the same.

Also, when I read these two formulas - "=R[-1]C*0.1" & "=F6*0.1" - I can
immedaitely tell that the first one is looking at the cell immediately above
the current one. The second formula could be pointing to any cell - I need to
know which cell I'm on to know whether it is right. Painful.

Also, how painful is the "A$1" stuff?

James.