Other Content

316 Lists&Spreadsheet Application
2. (Optional) To select adjacent rows or columns to delete, hold down Shift
and press ◄, ►, ▲, or ▼.
3. Display the context menu.
- Windows®: Right-click the selected row.
- Mac®: Hold the “ key, and click the selected row.
- Handheld: Press / b.
4. On the context menu, select Delete Row.
The selected rows or columns are deleted.
Note: If other cells contain formulas that refer to the deleted row or column,
those cells show an error. Relative references to cells whose positions
have changed because of a deletion adjust accordingly.
Copying Rows or Columns
1. Click the row number to copy a row, or click the column letter to copy a
column.
2. (Optional) To select adjacent rows or columns to copy, hold down Shift and
press ◄, ►, ▲, or ▼.
3. Copy the row or column:
Windows®: Press Ctrl+C.
Mac®: Press “+C.
Handheld: Press / C.
4. Move to any cell in the row or column where you want to place the copied
items.
5. Paste the row or column:
Windows®: Press Ctrl+V.
Mac®: Press “+V.
Handheld: Press / V.
The copied row or column is pasted in place, replacing the previous
contents.
Note: If you copy a named column, it is pasted with the name removed to
prevent a variable conflict.