Entering data: Using cell references
A1 notationRC notationRefers To
$A$1 R1C1 A cell in the 1st row and the 1st column.
This is the absolute reference: Inserting/deleting rows/columns and copying/pasting the cell don't change such references.
A1
R[0]C[0]
R[1]C[2]
R[-1]C[-2]
A cell in the 1st row and the 1st column.
This is the relative reference: inserting/deleting rows/columns and copying/pasting the cell may change references in formulas to retain the proper links between cells.
For example:
  • If you move/copy the '=B2' formula from the A1 cell to the C3 cell, it'll be replaced by '=D4'.
  • If you move/copy the '=B$2' formula from the A1 cell to the C3 cell, it'll be replaced by '=D$2'.
  • If you move/copy the '=$B2' formula from the A1 cell to the C3 cell, it'll be replaced by '=$B4'.
$1:$1
1:1
R1 The entire 1st row.
$A:$A
A:A
C1 The entire 1st column.
$1:$5 R1:R5 Rows 1 to 5.
$A:$E C1:C5 Columns 1 to 5.
$A$1:$E$5 R1C1:R5C5 A range of cells specified by the top-left A1 cell and the bottom-right E5 cell.
Sheet1!$A$1
'Sheet1'!$A$1
Sheet1!R1C1
'Sheet1'!R1C1
The 'A1' cell from the "Sheet1" worksheet in the same document.
Note:
  • Quotation marks delimiting the worksheet path/name can be skipped if that path doesn't contain any spaces or non-alphanumeric characters.
  • If the name itself contains quotation mark(s), it must be enclosed in quotation marks and the inner marks must be doubled.
'Folder1\Sheet1'!$A$1:$E$5 "Folder1\Sheet1"!R1C1:R5C5 The A1:E5 range from the "Folder1\Sheet1" worksheet in the same workbook.
'Folder1'!$A$1 "Folder1"!R1C1 The A1 cells (returned as one column) from all worksheets in the "Folder1" folder in the same workbook.
'Folder1'!$A$1:$E$5 "Folder1"!R1C1:R5C5 All cells from the A1:E5 ranges (returned as one column) from all worksheets in the "Folder1" folder in the same workbook.
'd:\documents\[sample.gsc]Sheet1'!$A$1
'd:\documents\[sample.gsc]Sheet1'!A1
"d:\documents\[sample.gsc]Sheet1"!R1C1 The A1 cell from the "Sheet1" worksheet in the d:\documents\sample.ods workbook.
Note:
  • If the reference includes a file path, the file name must be delimited by square brackets. The file path can be either absolute or relative. Relative paths (which is also true for empty/not specified paths) are resolved based on the path of the document where that reference is placed or - if the document is unsaved - the path of the last open document or the default document folder.
"d:\[sample.gsc]Folder1"!$A$1:$E$5 "d:\[sample.gsc]Folder1"!R1C1:R5C5 All cells from the A1:E5 ranges (returned as one column) from all worksheets in the "Folder1" folder in the d:\sample.ods workbook.