Other Content

312 Lists&Spreadsheet Application
Typing a Cell Reference in a Formula
1. Double-click the cell and type the formula. For more information, see the
Calculator section.
2. Move to the appropriate position in the formula and type the cell reference.
Use the format for a relative reference (B3), absolute reference ($B$2), or
range of cells (A1:A4).
Note: You can click Recalculate on the Actions menu to update all
references and formula results in a spreadsheet.
Deleting the Contents of Cells
1. Click a cell to select it.
—or—
Use the arrow keys to move to the cell.
Note: If you are deleting a range of cells, select a cell at one end or corner
of the range, and then use Shift with the arrow keys to select the remaining
cells in the range.
2. Press Del.
Note: Any cell that uses a formula with an absolute reference to deleted
data shows an error. A cell that uses a formula with a relative reference to
deleted data is updated to use the data currently in the referenced
position.
Copying Cells
When you copy cells, any formulas in the original cells are copied to the
destination cells.
1. Click the cell to copy.
—or—
Use the arrow keys to move to the cell.
Note: If you are copying a range of cells, select a cell at one end or corner
of the range, and then use Shift with the arrow keys to select the remaining
cells in the range.
2. Use the standard key shortcut for copying a selection.
Windows®: Press Ctrl+C.