Inserting a scroll bar into an Excel Sheet

Inserting a scroll bar into an Excel worksheet to enter data:

• Click the Scroll bar on the forms toolbar and drag across cell a6 as shown in the Excel training video
• Right-click the scroll bar and select the Format Control... to bring up a dialog box.
• Fill in the dialog box as shown in the training video with the 'cell link' to an appropriate cell (d6). This will allow interest rates to vary between 0 to 15% and the rate will be incremented by 0.25% each time the scroll bar is clicked. Click OK
• Click 'Esc' or away from the scroll bar to deselect it
• In cell C6 type the formula '='cell link address'/10000
• Now try out the scroll bar control!

The Excel training video demonstrates the concept in detail.

In the next video we will demonstrate the complete process. You can view the previous video on how to add a combo button to an Excel worksheet by clicking here.