Navigation:  Formula Reference > Formula OverView > Cell References in a Formula >

R1C1 Notation

Previous pageReturn to chapter overviewNext page

 

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