Chapter 9 Working with Table Cells 195
You can enlarge a cell so that it displays more content, or you can let the cell’s content
spill into adjacent blank cells.
To avoid clipping and spilling, you can set up a table so that all its cells automatically
shrink or expand in height to accommodate content by selecting “Automatically resize
to t content” in the Table inspector’s Table pane.
Here are ways to handle content too large for a cell:
To let the content in a cell spill into adjacent cells, deselect Wrap Text in the Table m
inspector’s Format pane and deselect “Automatically resize to t content” in the
Table pane.
If the adjacent cells are empty, they display spilled content. But if they contain data,
content that doesn’t t isn’t displayed, and the clipping indicator appears.
To make content wrap instead of spill, select Wrap in the format bar or Wrap Text in
the Table inspector’s Format pane.
To resize a column so that all of a particular cell’s value is visible, click its right border m
and drag right, or use the Column Width controls in the Table inspector’s Table pane.
To resize a row so that all of a particular cell’s value is visible, click its bottom border m
and drag down, or use the Row Height controls in the Table inspector.
Using Conditional Formatting to Monitor Table Cell Values
Conditional formatting changes a cell’s appearance when the cell contains a particular
value, referred to below as a test value.
To apply conditional formatting, you select one or more cells and then dene one or
more rules. The rules specify which visual eects to associate with cells when they
contain the test value.
For example, you can dene a rule that lls a cell with blue when it contains 0, a rule
that displays the cell’s value as boldface black if it’s greater than 0, and a rule that lls
the cell with red if its value is less than 0.
Rules applied to multiple cells trigger conditional formatting when any of the cells
contains the test value.
To learn how to Go to
Create rules “Dening Conditional Formatting Rules” on
page 196
Remove all conditional formatting from cells,
change rules, nd cells that use the same
conditional formatting, copy/paste conditional
formatting between tables
“Changing and Managing Your Conditional
Formatting ” on page 197
Comments to this Manuals