•On the View tab, select the R1C1 reference style checkbox.
•When working in macOS, select the View > R1C1 command from the command menu.
In the R1C1 style, both columns and rows are denoted by numbers. The address of a cell is determined using the formula RnCm, where:
•R stands for Row, and n stands for row number.
•C stands for Column, and m stands for column number.
For example, the name of D5 cell in the R1C1 style is R5C4.
Absolute reference |
R3C2 (an absolute reference to a cell at the intersection of row 3 and column 2) R3 (an absolute reference to row 3) C2 (an absolute reference to column 2) |
|---|---|
Relative reference |
RC (a relative reference to the current cell) R[-2] (a relative reference to the row located 2 rows above the current row) C[3] (a relative reference to the column located 3 columns to the right of the current column) |
Mixed reference |
RC5 (a reference to a cell in the current row in column 5) RC[-5] (a reference to a cell located in the current row 5 columns to the left of the current cell) R3C[2] (a reference to a cell located in row 3, 2 columns to the right of the current cell) R[3]C[-2] (a reference to a cell located 3 rows below and 2 columns to the left of the current cell) R[-3]C[2] (a reference to a cell located 3 rows above and 2 columns to the right of the current cell) |