09

Displaying Content Too Large for Its Table Cell
When a cell is too small to display all its content, here is what happens:
If the content is a number or date, a clipping indicator appears. Â
The clipping indicator
For other types of values, no clipping indicator appears. You can only see content Â
that’s visible within the boundaries of its cell.
Here are ways to handle content too large for a cell:
To let a value in a cell spill into adjacent cells, deselect Wrap in the format bar or m
deselect “Wrap Text in Cell” in the Cells inspector. Numbers and dates clip instead of
spill, even with wrap deactivated.
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
Cell” in the Cells inspector.
If cell values aren’t visible because columns are too narrow, you can use the Fit button m
next to the Column Width controls in the Table inspector to make values visible. Select
a cell, one or more columns, or the table, and then click the Fit button.
You can also resize a column by dragging the right border of its reference tab to the
right, or by using the Column Width controls in the Table inspector.
If cell values aren’t visible because rows are too narrow, you can use the Fit button m
next to the Row Height controls in the Table inspector to make values visible. Select
a cell, one or more rows, or the table, and then click the Fit button. As row content is
added or removed, row height automatically changes to match content height.
You can also resize a row by clicking the bottom border of its reference tab and
dragging down, or by using the Row Height controls in the Table inspector.
You can also resize columns and rows to accommodate content by using the m
reference tabs.
To increase the height of a row to accommodate its largest content, double-click the
lower border of the row’s reference tab. Column width does not adjust automatically
when you make content changes.
To increase the width of a column to accommodate its largest content, double-click
the right border of the column’s reference tab.
Using Conditional Formatting to Monitor Table Cell Values
Conditional formatting changes a cell’s appearance when the cell contains a particular
value, referred to as a test value.
82 Chapter 4 Working with Table Cells