To add a scroll bar (slider) in Excel

From the VIEW menu, select Toolbars, and check Control Toolbox.

This brings up a toolbox with a blue architect's triangle with its background highlighted. The highlighted triangle means you are in Design Mode. In this mode you install and modify items from the toolbox.
In the toolbox, click once on the Scroll Bar (vertically separated triangles). (There is balloon help which will identify each item as you move the mouse over it.) Scroll bars are also referred to as sliders.
After clicking once on a scroll bar, move the mouse to the spreadsheet and drag over a rectangular area which will be the region for your scroll bar (slider).
Now right click (click on the right mouse button) inside the slider area. 
This brings up a menu, and on this menu select (click on) Properties.
A list of properties will appear. Decide on the cell to receive the output of the slider (possibly a cell next to the slider itself), like F3, and enter this cell on the line for Linked Cell.
Exit Design Mode by clicking once on the architect's triangle to un-highlight it.
Now try out your slider by dragging the slider bar around, causing numerical values to appear.

The slider values are integers starting from a default Min of 0 to a default maximum of 32767.
To change the maximum value, click on the triangle to enter Design Mode, then right-click on the slider, then select (click on) Properties and change Max to something else, like 1000.
Then exit design mode by clicking on the triangle. Now try changing your slider.
(The little triangles at each end of the slider change its value by 1 each time you click.)

In the pV spreadsheet, we made a slider for the extra volume, and also for the atmospheric pressure correction. Then we plotted volume vs. pressure. We also made volume, pressure and pV columns, using the sliders to add in the extra factors. Then we averaged all this pV data and used this average to get 'corrected' volumes by dividing the average pV value by the corrected pressure. Then two series were plotted:  original volume vs. original pressure, and corrected volume vs. original pressure. The idea was to play with the sliders to make the two series coincide as much as possible.

Sample spreadsheets of several different types are available at 

http://www.rose-hulman/~moloney

•	sine wave plot using a slider to change the frequency
•	pV plot with corrections
•	travelling wave animation, animated by recalculating the time
•	pipe resonance calculation, varying the frequency to find resonances
•	Boltzmann factor spreadsheet, illustrating the use of Visual Basic underneath Excel