Scroll Bar

To insert a scroll bar in your Excel worksheet you would first have to open the developer tabs.

Follow these steps


To open the “DEVELOPER” tab, place your cursor at the menu bar and right click anywhere. Select “Customize the Ribbon” from the drop down menu.


Customize The Ribbon


The option dialog box will open. In the option dialog box Under “Customize the Ribbon Main Tabs” select the Developer check box and click on the ok button.

Add Developer Tab


The developer tap is now visible and is present next to the view tab on the top menu bar. Now click on the developer tab, select insert and then Scroll Bar (Form Control).

Insert Scroll Bar


Right click on the scroll bar and click anywhere on your worksheet. You have now inserted a scroll bar.

Scroll Bar


Right click on the scroll bar. Select format control from the dropdown menu and then go to the controls tab. Insert values you would like in here and that’s it! You have done it!

Scroll Ber Format Control

Cell Link