How do I add sliders in Excel 2013?

1) Turn on DEVELOPER

Open Excel, then File, Options, Customize Ribbon, Check Developer

2) Insert Scroll Bar (Slider) from Developer Tab

Developer, Insert, Scroll Bar (Under Form Contols) then left click and size control bar

3) Customize Slider

Right click on Slider, Format Control

4) Select Slider Options – Min and Max Values

5) Select Slider Options – CELL LINK

You need to decide what cell you want your slider value to be stored in

Click cell link, click cell in spreadsheet where you want sliders values to go

6) Test your slider

Click off of the slider and then back on it and scroll right and left (or up and down)

Your sliders values should now be linked to the cell you chose

7) Join your slider to your table value

You will now need to change the formula in your “yellow” cell to link your slider to the

table.

The slider is programed to return 1 to 20. If you want your values to be -10 to 10, then

change the formula in the yellow cell to (linked cell) – 10

8) Repeat the process until you’ve added all sliders that you wish to add.