Apple Numbers '09 User Manual

Page 101

Advertising
background image

Chapter 4

Working with Table Cells

101

To remove an item, select it and click the Delete button (–).
To add a stepper, click the Cell Formats button in the format bar and then choose

m

Stepper in the pop-up menu to create a stepper with default settings.
You can also open the Cells inspector and choose Stepper from the Cell Format pop-
up menu.
In the Cells inspector, change the default settings if desired:
Minimum and Maximum: Indicates the lowest and highest cell values.
Increment: Indicates the amount by which the cell value increases or decreases when
you click the stepper control (or an arrow key) once.
Display as: Applies a number, currency, percentage, fraction, scientific, or numeral
system format to the cell values.
Decimals: Indicates how many decimal places to display.

Using Your Own Formats for Displaying Values in Table Cells

You can create your own cell formats for displaying numbers, text, and date and time
values. Cell formats you create, called custom formats, are listed in the Cell Formats
pop-up menu in the format bar.

Custom formats are also listed in the Cell Format pop-up menu in the Cells inspector.

To learn how to

Go to

Define a custom number format that applies
currency, decimal digit, and other display
formatting to a number in a table cell

Creating a Custom Number Format” on page 102
Defining the Integers Element of a Custom
Number Format
” on page 104
Defining the Decimals Element of a Custom
Number Format
” on page 105
Defining the Scale of a Custom Number
Format
” on page 106

Define custom number formatting that varies
with the value of a number in a table cell

“Associating Conditions with a Custom Number
Format
” on page 108

Define a custom date/time format, which
specifies day, month, year, hour, minute, and other
aspects of a date/time value in a table cell

Creating a Custom Date/Time Format” on
page 110

Define text you want to appear next to a value
entered into a table cell

Creating a Custom Text Format” on page 111

Manage the custom formats you create

Changing a Custom Cell Format” on page 112
Reordering, Renaming, and Deleting Custom Cell
Formats
” on page 113

Advertising