In Excel 2007:
Office button (top left)Excel OptionsFormulas tab, check R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Elisabeth" wrote in message ...
| 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.
|
|