User Guide

Use the Formula Editor and formula bar to add and edit formulas. See “ m Adding and
Editing Formulas Using the Formula Editor” on page 119 and “Adding and Editing
Formulas Using the Formula Bar” on page 12 0 for details.
Use the Function Browser to add and edit functions. See “ m Adding Functions to
Formulas” on page 121 for details.
Resizing a Table
You can make a table larger or smaller by dragging one of its selection handles
or by using the Metrics inspector. You can also change the size of a table by resizing
its columns and rows.
Before resizing a table, select it by clicking its name in the Sheets pane or using one of
the other techniques in “Selecting a Table” on page 52.
Here are ways to resize a selected table:
Drag one of the square selection handles that appear when a table is selected. m
To maintain a table’s proportions, hold down the Shift key as you drag.
To resize from the table’s center, hold down the Option key as you drag.
To resize a table in one direction, drag a side handle instead of a corner handle.
To resize by specifying exact dimensions, select a table or table cell, click Inspector in m
the toolbar, and then click the Metrics inspector button. Using the Metrics inspector,
you can specify a new width and height, and you can change the table’s distance from
the margins by using the Position elds.
To resize by adjusting the dimensions of rows and columns, see “ m Resizing Table Rows
and Columns” on page 62.
Moving Tables
You can move a table by dragging it, or you can relocate a table using the Metrics
inspector.
Here are ways to move a table:
If the table isn’t selected or if the entire table is selected, press the edge of the table m
and drag it.
If a table cell is selected, drag the table using the Table handle in the upper left.
48 Chapter 3 Using Tables