User Guide

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, scientic, 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
Dene 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 99
“Dening the Integers Element of a Custom
Number Format” on page 101
“Dening the Decimals Element of a Custom
Number Format” on page 102
“Dening the Scale of a Custom Number
Format” on page 103
Dene custom number formatting that varies
with the value of a number in a table cell
“Associating Conditions with a Custom Number
Format” on page 105
Dene a custom date/time format, which
species 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 107
Dene text you want to appear next to a value
entered into a table cell
“Creating a Custom Text Format” on page 108
Manage the custom formats you create “Changing a Custom Cell Format” on page 109
“Reordering, Renaming, and Deleting Custom Cell
Formats” on page 110
98 Chapter 4 Working with Table Cells