Spread Formula Reference
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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options