Using Table Tools
You can format a table and its columns, rows, cells, and cell values using various
Numbers tools.
Here are ways to manage table characteristics:
Select a table by clicking its name in the Sheets pane, and use the format bar to
m
quickly format the table. “Selecting a Table” on page 55 describes other ways to select
a table.
Arrange text in table cells.
Format cell borders.
Add background
color to a cell.
Format cell values.
Manage headers
and footers.
Show or hide a table’s name.
Format text in
table cells.
48
Chapter 3
Using Tables
Chapter 3
Using Tables
49
Use the Table inspector to access table-specific controls, such as fields for precisely
m
controlling column width and row height. To open the Table inspector, click Inspector
in the toolbar, and then click the Table inspector button.
Add a table name.
Merge or split
selected cells.
Adjust the size of rows
and columns.
Set the style, width, and
color of cell borders.
Add color or an image
to a cell.
Change the behavior
of the Return and
Tab keys.
Add or remove 1-5 header
rows, header columns, and
footer rows.
Use the Cells inspector to format cell values. For example, you can display a currency
m
symbol in cells containing monetary values. Cell formats determine how cell values
are displayed, but they never change the underlying cell value used in calculations. For
example, a cell with the actual value of 4.29 might be displayed as 4.3, but calculations
use the value 4.29.
You can also set up conditional formatting. For example, you can make a cell red when
its value exceeds a particular number.
To open the Cells inspector, click Inspector in the toolbar, and click the Cells
inspector button.
The buttons at the top of the
inspector window open the
ten inspectors: Document,
Sheet, Table, Cells, Chart, Text,
Graphic, Metrics, Hyperlink,
and QuickTime.
Use the Graphic inspector to create special visual effects, such as shadows. To
m
open the Graphic inspector, click Inspector in the toolbar and then click the Graphic
inspector button.
Use table styles to adjust the appearance of tables quickly and consistently. See “
m
Using
Table Styles” on page 114 for more information.
Use the reference tabs and handles that appear when you select a table cell to quickly
m
reorganize a table, select all the cells in a row or column, add rows and columns, and
more. “Selecting a Table Cell” on page 55 describes how to select a table cell.
Drag the Table handle
to move the table.
Reference tab letters can be
used to refer to columns.
Click the Column handle to
add one column. Drag it to
add multiple columns.
Reference tab
numbers can
be used to
refer to rows.
Drag the Column and Row
handle down to add rows. Drag it
to the right to add columns. Drag
it diagonally to add rows and
columns at the same time.
Click the Row handle to add one row.
Drag it to add more rows.
You also use reference tabs when you work with formulas (“Referring to Cells in
Formulas” on page 126 explains how).
Access a shortcut menu by selecting a table or one or more cells and then holding
m
down the Control key as you click again.
50
Chapter 3
Using Tables
Chapter 3
Using Tables
51
You can also use the pop-up menus on the column and row reference tabs.
Use the Formula Editor and formula bar to add and edit formulas. See “
m
Adding and
Editing Formulas Using the Formula Editor” on page 122 and “Adding and Editing
Formulas Using the Formula Bar” on page 123 for details.
Use the Function Browser to add and edit functions. See “
m
Adding Functions to
Formulas” on page 124 for details.