Скачать или смотреть How to Insert Scrollbar in Excel - A Quick Tutorial

Learn: The Quick & easy way on How to Insert Scrollbar in Excel

In this video, you will learn:
1. How to Insert Scrollbar in Excel
2. Add a scroll bar or spin button to a worksheet

In this video tutorial I am going to teach you, Scrollbar in Excel, How to Insert Scrollbar in excel, Setting up a Scrollbar and How to Use Scrollbar

A scroll bar in Excel is just like the one you have seen in many places while using a computer system. This is a thin bar mainly displayed in most computer applications to move the viewing area of computer applications, left and right or up and down. Based on the direction of movement, the scrollbar is of two types:
1. Horizontal Scroll Bar (Moves left and right)
2. Vertical Scroll Bar (moves up and down)

To create the SCROLLBAR in Excel, follow these steps:
First, you need to enable the Developer tab visible on the ribbon so you can get to the VBA and the ActiveX control commands. To get the Developer tab, follow the below steps:
• Click on the Excel File option to bring up the Excel Options dialog box. Scroll down and click Option
• Click Customize Ribbon.
• Select the Developer Check box.
• Now, click on the Excel Ribbon at the top, then select the Developer tab.
• Click on Insert, then click the SCROLLBAR control to insert the new list box in excels worksheet.
• After that, draw a rectangle in the excel worksheet to insert a ScrollBar.
If you will like to move the rectangle spread more horizontally, then the Horizontal Scroll Bar control will be inserted in Excel.
If you will like to move the rectangle spread more vertically, then a vertical scrollbar will be inserted in Excel.

After inserting the scroll bar based on the explanations I made earlier, just right-click on the scroll bar and select the FORMAT CONTROL option:

This will open a dialogue box. In the dialogue box, here are the following options available:

1. Current Value
2. Minimum Value
3. Maximum Value
4. Incremental Change
5. Page Change
6. Cell Link
……………………………………………………………………………………………………………………….
Share this video:    • How to Insert Scrollbar in Excel - A Quick...  

For more simple and easy to follow How to videos,

Click the Link Below to subscribe:
   / @learnexcelwitht  

Join this channel to get access to perks:

   / @learnexcelwitht  

#scrollbars #excelscrollbar #addscrollbar

LearnexcelwithT