Chapter 9 Working with Table Cells 201
To show all comments, choose View > Show Comments. m
To delete a comment, click the X in the upper right of the comment box. m
To include all comments when you print, show any comments you want to print, and m
then choose File > Print.
Formatting Table Cell Values for Display
You can apply a format to a cell to display its value in a particular way. For example,
you can apply the currency format to cells that hold monetary values so that a
currency symbol (such as $, £, or ¥) appears in front of numbers in the cells.
When you use a cell format, you are setting only the display characteristics of a value.
When the value is used in formulas, the actual value is used, not the formatted value.
The only exception is when there are too many numbers following a decimal point, in
which case the number is rounded.
Here are ways to work with cell formats:
You apply cell formats by selecting one or more cells and then using the Cell Format m
pop-up menu in the Table inspector’s Format pane.
To add a value to an empty cell that has a format, select the cell and enter a value. The m
format is applied when you leave the cell.
If you delete a value from a cell with a format, the cell’s format isn’t deleted. To delete m
the format, apply the automatic format. To delete the value and format, choose Edit >
Clear All.
After you dene a cell format, you can associate the format with multiple cells by using m
autolling. See “Autolling Table Cells” on page 193 for instructions.
Use this cell format When you want to Learn more here
automatic Automatically format
content based on the
characters it contains
“Using the Automatic Format in
Table Cells” on page 202
number Format the display of a
number’s decimal places,
thousands separator, and
negative values
“Using the Number Format in
Table Cells” on page 203
currency Format the display of
monetary values
“Using the Currency Format in
Table Cells” on page 204
Comments to this Manuals