Using Sliders

You can use the novel slider input control options available in Numbers to test different what-if scenarios. Sliders let you make rapid changes to the contents of a cell.

To format a cell as a slider:

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

Numbers places an initial value in the cell and, next to that cell, displays a slider you can drag to the left or the right to quickly change the value. You can also change the characteristics of the values presented in the cell when you move the slider.

To modify cell content using sliders:

  1. Select a cell.
  2. Click the Inspector button in the toolbar to open an Inspector window.
  3. Click the Cell Inspector button.

You can specify the minimum and maximum values and set the increment by which the values will change as you move the slider left and right. You can also tell Numbers where to position the slider and how to format the value displayed in the cell.