How to Change to R1C1 Cell Reference in Excel 2007

By DanaZ

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.

Step 1

Open Microsoft Excel 2007.

Step 2

Click on the "Office" button in Excel.

Step 3

Click on "Excel Options."

Step 4

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

Step 5

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.

Tips & Warnings

  • The "R1C1" reference style has advantages in calculating cell locations in macros.
  • Worksheets created under the "A1" reference style may not work until the reference style has been changed back to "A1" by clearing the "R1C1 reference style" check box.