Tools -- Options -- General Tab
Check the box for R1C1 reference style
--
Elisabeth


"duke1957" wrote:

I have Office 2007 and want to use R1C1 reference not A1. There is a
reference to R1C1 in a Help topic but no mention of how to get to it. I have
old files which I want to remain R1C1 because of the convenience of counting
columns to duplicate. For instance, copying a function in column 6 to ten
additional columns takes it to column 16. Copying it from column E takes it
to column O, not very intuitive.