Things You'll Need:
- Microsoft Excel 2003 to 2007
-
Step 1
Open the "Forms" toolbar in Excel 2003 by going to the "View" menu, pointing to "Toolbars" and selecting "Forms." Click the scroll bar button on this toolbar. Click on the first cell onto which you want to place the scroll bar and drag the mouse to the last cell onto which you want to place the scroll bar. In Excel 2007, go the "Developer" tab. Click "Insert" and select "Scroll Bar" in the "Form Controls" group. Click on the first cell onto which you want to place the scroll bar and drag the mouse to the last cell onto which you want to place the scroll bar.
-
Step 2
Right-click the scroll bar on the Excel worksheet. Select "Format Control." The "Format Control" dialog box will open. Go to the "Control" tab.
-
Step 3
Enter "1" into the "Current Value" box to enable the scroll bar and direct the "Index" formula to refer to the first item in the range or list. Type "1" into the "Minimum Value" box, which confines the scroll bar to stop at the first item in the list or range. In the "Maximum Value" box, type the number of entries in the list or range to limit the scroll bar to the last item. Type the number of increments by which you want to be able to scroll in the "Incremental Change" box. Type an incremental number in the "Page Change" box, as well. This form control dictates the increments the scroll bar will move if the users clicks the scroll arrows.
-
Step 4
Type a cell reference into the "Cell Link" box or click inside the "Cell Link" box to place the cursor in it and then click on the cell you wish to use to display the number value showing the item selected when the scroll bar is in use.
-
Step 5
Click "OK" to save the changes and close the dialog box. Click onto the Excel worksheet anywhere outside of the scroll bar. Your scroll bar will now be functional.
