Scrolling, Scrolling, Scrolling!

If you have a spreadsheet that needs incremental updates of the numbers in certain cells, clicking on the cells and typing in the subsequent number can be tedious. Using a Scroll Bar can make it considerably easier to increase (or decrease) a value, such as a number, time, or date by allowing you to Scroll through a range of values when you click the scroll arrows or when you drag the scroll box. Besides that, it makes your Excel worksheet look very cool!

Here is how you do it on Excel 2007 and 2010:

1. Choose the Developer tab and go to Insert on the Controls grouping
2. Click the Scroll Bar under the Forms Controls section
3. Draw the bar next to the cell you want it to control (it can be either vertical or horizontal)
4. Right-click on your new Scroll Bar and choose Format Control
5. Select the Control tab on the Form Control and choose your own custom parameters
6. Insert the cell reference in the Cell link (e.g. $A$1)

Here is how you do it on Excel 2003 and Earlier Versions:

1. Go to the Forms toolbar and click the Scroll Bar
2. Draw the bar next to the cell you want it to control (it can be either vertical or horizontal)
3. Right-click on your new Scroll Bar and choose Format Control
4. Select the Control tab on the Form Control and choose your own custom parameters
5. Insert the cell reference in the Cell link (e.g. $A$1)

Bamm! There you have it! Not only will this save you tedium, it will make you look like the Excel Rock Star that you are!