Formula Overview > Cell References in a Formula > R1C1 (Number-Number) Notation |
Each cell can be referenced by its row and column number by preceding each by the letter "R" for row and the letter "C" for column. For example R1C3 is the cell in the first row and third column.
A1 Cell Ref. | R1C1 Cell Ref. | Description |
---|---|---|
B12 | R12C2 | Cell in the second column (column B) and twelfth row (row 12) |
D14:D48 | R14C4:R48C4 | The range of cells in the fourth column (column D) and in rows 14 through 48 |
E16:H16 | R16C5:R16C8 | The range of cells in the sixteenth row (row 16) in the fifth through the eighth column (columns E through H) |
A25:E70 | R25C1:R70C5 | The range of cells in the first five columns (column A through E) and rows 25 through 70 |
See also these topics:
For more information on setting the reference style for a cell, refer to the ReferenceStyle enumeration in the product’s Assembly Reference (or help) and the ReferenceStyle property for the specific sheet (SheetView object).
Return to Cell References in a Formula