Copying and Moving Cells
Here are ways to copy and move cells:
To move cells within a table, to another table, or to the canvas, select a cell or several
m
adjacent cells, and then when the pointer changes to a white cross drag the selection
until any destination cells are selected. Values in the destination cells are replaced, and
the values in the original location are removed.
To copy cells within a table, to another table, or to the canvas, drag selected cells while
m
holding down the Option key. Any values in the destination cells are replaced, and the
values in the original location are retained.
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.
To insert copied cells without overwriting destination cells, choose Insert > Copied
m
Columns or choose 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 you paste a cell’s contents into a different cell, any comment associated with the
pasted content is also pasted.
If you delete the contents of a cell, any comment associated with the cell is removed.
88
Chapter 4
Working with Table Cells
Chapter 4
Working with Table Cells
89
See “Rearranging Rows and Columns” on page 61 to learn how to copy and move rows
and columns using the reference tabs.
See “Copying or Moving Formulas and Their Computed Values” on page 131 to learn
about techniques for duplicating or moving a cell that contains a formula.