Apple numbers User Manual

    Using Tables 

 

You can use commands or dragging to move or copy table 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.

Use comments to record information about table cells. 

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.