Apple Numbers '09 - Manual (Page 89)

Chapter 4 Working with Table Cells 89
See “Rearranging Rows and Columns” on page 61 to learn how to copy and move rows
and columns using the reference tabs.
See “Copying or Moving Formulas and Their Computed Values” on page 131 to learn
about techniques for duplicating or moving a cell that contains a formula.
Adding Comments to Table Cells
Use comments to record information about table cells.
Here are ways to work with comments:
To add a comment to a cell, select the cell and click Comment in the toolbar, or choose
m
Insert > Comment. Type in the comment box.
To move a comment, drag it.
m
To hide all comments, choose View > Hide Comments. A yellow marker appears in any m
table cell containing a comment.
To hide one comment, click the Minimize (–) button in the upper left of the comment
box, or click the comment marker. A hidden comment can be temporarily displayed by
placing the pointer over the marker.
To show all comments, choose View > Show Comments.
m
To show a hidden comment, click its marker.
To delete a comment, click the X in the upper right of the comment box.
m
To include comments when you print, show any comments you want to print, m
and 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 format bar or
m
the Cell Format pop-up menu in the Cells inspector to select the format.
To add a value to an empty cell that has a format, select the cell and enter a value.
m
The format is applied when you leave the cell.