beautypg.com

Formatting table cell values for display, 201 formatting table cell values for display, 201 de – Apple Pages '09 User Manual

Page 201

background image

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 define a cell format, you can associate the format with multiple cells by using

m

autofilling. See “Autofilling 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