How to Change to R1C1 Cell Reference in Excel 2007

By default, Excel uses the "A1" reference style for referencing cells in formulas. In this reference style, "A" refers to the column name and "1" refers to the row number. Some older versions of Excel use the "R1C1" reference style where "R1" refers to the row number and "C1" to the column number. To allow processing of formulas with "R1C1" references, you will need to enable the "R1C1" reference style in Excel.

Young businesswoman eating lunch at desk
You can change the "R1C1" reference style in Excel.
credit: Siri Stafford/Digital Vision/Getty Images

Step

Open Microsoft Excel 2007.

Step

Click on the "Office" button in Excel.

Step

Click on "Excel Options."

Step

Click on "Formulas," in the left-hand pane of the "Excel Options" box.

Step

Check the "R1C1 reference style" check box under "Working with formulas" to enable "R1C1" style referencing. Clear this check box to use "A1" style referencing.