Cell references

A1 notation	RC notation	Refers 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.