Using Steppers

Whereas sliders let you quickly make relatively large changes to the value in a cell, steppers are more suited to specific incremental changes.

To format a cell as a stepper:

  1. Select a cell.
  2. Choose Stepper from the More Cell Formats button in the Format Bar.

When a cell is formatted as a stepper, Numbers adds up and down arrows immediately to the right of the cell (when selected) that you use to increment the value in the cell. By default, Numbers sets the increment value to 1, but you can change it.

To change the increment value in a Stepper cell:

  1. Select a cell.
  2. Click the Cells Inspector button in the Inspector window and adjust the available parameters.

When formulas you’ve set up in your tables or charts depend on the values in cells formatted as sliders or steppers, you can immediately see the effects of the incremental changes made as part of your what-if scenarios.