You can switch to the R1C1 reference style in several ways:
–On the View tab, select the R1C1 reference style checkbox.
–When working in macOS, select View > R1C1 from the command menu.
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. |