CellRange[Start
Cell, End Cell]: Creates a list containing the cell values in
this cell range.
Example: Enter the following values into the
corresponding spreadsheet cells:
A1 = 1, A2 = 4, A3 = 9. The command CellRange[A1, A3] then gives
you the list {1, 4, 9}.
Column[Spreadsheet
Cell]: Returns the column of the cell as a number (starting at 1).
Example: Column[B3]
gives you number a = 2 since column B is the second column of the
spreadsheet.
ColumnName[Spreadsheet
Cell]: Returns the column name of the cell as a text.
Example: ColumnName[A1]
gives you a text “A” in the Graphics View.
Row[Spreadsheet
Cell]: Returns the row number of a spreadsheet cell (starting at
1).
Example: Row[B3]
gives you number a = 3.