09

Chapter 4 Working with Table Cells 99
For more control over the number of decimal places, use the Cells inspector.
To dene a scientic format for one or more cells using the Cells inspector:
1 Select the cell or cells.
2 Click Inspector in the toolbar, and then click the Cells inspector button.
3 Choose Scientic from the Cell Format pop-up menu.
4 Use the Decimals eld to specify the number of decimal places to display.
Using the Text Format in Table Cells
Use the text format when you want all of a cell’s content to be treated as text, even
when it’s a number. When a text format is applied to a cell, its value is displayed exactly
as you type it.
Here are ways to dene a text format for one or more selected cells:
Click the Cell Formats button in the format bar and then choose Text. m
Click Inspector in the toolbar, click the Cells inspector button, and then choose Text m
from the Cell Format pop-up menu.
Using a Checkbox, Slider, Stepper, or Pop-Up Menu in Table Cells
You can add a checkbox, slider, stepper, or pop-up menu to a cell:
Checkbox: Useful for cells whose value indicates one of two states, such as on or o,
or yes or no.
Slider: Useful for quickly making large changes to numbers so you can see the eects
of the changes on other cells in the table or on a chart.
Stepper: Use to increase or decrease numbers in specic increments.
Pop-up menu: Use to predene the values a cell can contain.
When a cell is formatted to use a checkbox or pop-up menu, you can add or change a
cell’s content only by using the control. Cells that use a slider or stepper let you type a
value into the cell or use the control.
Here are ways to add controls to cells:
To add a checkbox, select the cell or cells. m