Microsoft Excel: Scroll bar / slider bar tutorial
Microsoft Excel: Scroll bar / slider bar tutorial
Full instructions:
1. Go to the developer tab (make sure it's enabled)
2. Click 'Insert', 'Form Controls', and click 'Scroll bar'.
3. Draw the scroll bar on your sheet
4. To link it to a cell, right-click and select 'Format control'
5. Set cell link to the cell, in this example 'B3'.
6. Set minimum and maximum value for the cell
7. Click 'OK'.
Done. The slider is now linked to the value in the cell. By clicking on the arrows, or moving the slider, you'll change the values in the cell.
On this page of the site you can watch the video online Microsoft Excel: Scroll bar / slider bar tutorial with a duration of hours minute second in good quality, which was uploaded by the user PC tutorials 23 March 2017, share the link with friends and acquaintances, this video has already been watched 28,816 times on youtube and it was liked by 105 viewers. Enjoy your viewing!
