To switch to the R1C1 reference style, on the View tab, select the R1C1 reference style checkbox.
In R1C1 style, both columns and rows are designated by numbers. The cell address is generated using the formula RnCm, where:
–R: Row designation, and n is the row number.
–C: Column designation, and m is the column number.
For example, the D5 cell name in R1C1 style is R5C4.
Relative reference |
RC: Relative reference to the current cell. R[-2]: Relative reference to the row located two rows above the current row. C[3]: Relative reference to the column located three columns to the right of the current one. |
Absolute reference |
R3C2: Absolute reference to the cell located at the intersection of row 3 and column 2. R3: Absolute reference to row 3. C2: Absolute reference to column 2. |
Mixed references |
RC5: Reference to the cell located in the current row, in column 5. RC[-5]: Reference to the cell located in the current row, five columns to the left of the current cell. R3C[2]: Reference to the cell located in row 3, two columns to the right of the current cell. R[3]C[-2]: Reference to the cell located three rows below and two columns to the left of the current cell. R[-3]C[2]: Reference to the cell located three rows above and two columns to the right of the current cell. |