User Guide

To insert content within existing content, select the cell, click to set the insertion point, m
and begin typing.
To undo changes made to a table cell since selecting the cell, press Esc. m
To delete the content of table cells, rows, or columns, select the cells, rows, or columns m
and then press the Delete key or choose Edit > Delete.
To delete the contents, background ll, and any style settings, choose Edit > Clear All.
The default style is applied to the selection.
To copy, paste, and move cell values, see the instructions in “ m Copying and Moving
Cells” on page 85.
To add formulas and functions to cells, see the instructions in “ m Creating Your Own
Formulas” on page 118 .
Working with Text in Table Cells
You can control the format and alignment of text in table cells, and you can use
nd-and-replace and spell-checking features.
When you type text into a cell, Numbers displays text that might be used to
complete the cell content based on similar text elsewhere in the table. You can
use the suggested text if it’s appropriate, or you can keep typing to override
suggestions. To disable auto-suggestions, deselect “Show auto-completion list in table
columns” in the General pane of Numbers preferences.
Here are techniques for working with text in table cells:
To insert a line break, press Option-Return. m
To insert a paragraph break, if “Return key moves to next cell” below Table Options in m
the Table inspector isn’t selected, press Return. Otherwise, press Option-Return.
You can also click in the formula bar and click the line break button in the format bar.
To insert a tab in a table, press Option-Tab. m
You can also click in the formula bar and click the tab button in the format bar.
To adjust text alignment, use the alignment buttons in the format bar. m
Align text to the left, center, right; justify text; or
align text to the left and numbers to the right.
Align text to the top, middle,
or bottom of cells.
The Text inspector gives you additional text formatting options (click Inspector in the
toolbar and click the Text inspector button).
See “Setting Text Alignment, Spacing, and Color” on page 170 for more information.
76 Chapter 4 Working with Table Cells