Copying and moving cells, Adding comments – Apple Numbers '08 User Manual

Page 76

Advertising
background image

76

Chapter 3

Using Tables

Copying and Moving Cells

You can use commands or dragging to move or copy table cells.

Here are ways to copy and move cells:

m

To move cells within a table or to another table, select a cell or several adjacent cells,
and then drag the selection by its border until the destination cells are selected. Any
values in the destination cells are replaced.

m

To copy cells within or between tables, drag selected cells while holding down the
Option key. Any values in the destination cells are replaced.

You can also copy cells by selecting them, choosing Edit > Copy, selecting destination
cells, and then choosing Edit > Paste.

You can also paste a cell’s content into multiple cells, which don’t have to be adjacent to
the copied cell or to each other. After copying a cell, select the destination cells and
choose Edit > Paste. The cell’s contents are copied to all the destination cells, in the
same or another table, replacing any existing content.

m

To insert copied cells without overwriting destination cells, choose Insert > Copied
Columns or Insert > Copied Rows after selecting destination cells.

Copied Columns: Adds new columns to accommodate copied cells.

Copied Rows: Adds new rows to accommodate copied cells.

When a cell value is replaced, so is any comment associated with the cell.

See “Rearranging Rows and Columns” on page 70 to learn how to copy and move rows
and columns using the reference tabs.

See “Copying or Moving Formulas with Cell References” on page 92 to learn about
techniques for duplicating or moving a cell that contains a formula.

Adding Comments

Use comments to record information about table cells.

Here are ways to work with comments:

m

To add a comment to a cell, select the cell and click Comment in the toolbar. Type in
the comment box.

m

To move a comment, drag it.

m

To hide all comments, choose View > Hide Comments. A yellow marker appears in any
table cell containing a comment.

To hide one comment, click the “–” in the upper right of the comment box.

m

To show a hidden comment, click its marker.

To show all comments, choose View >Show Comments.

Advertising