Mini Scroll Bar Widget - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Discover how to create a mini scroll bar widget. Also learn how to create a vertical scroll bar in Excel, and how to create scrolling table in Excel. I will show you how to add scroll bar in excel sheet in the process.   These are the steps outlined in the video.   Enable Developer Ribbon  1) Right-click anywhere in the ribbon  2) Customized the Ribbon...  3) Check on Developer  4) OK   Here are the steps outlined in this video.  1) Ctrl+C  2) Ctrl+V  3) Developer ~ Control ~ Insert ~ Scroll Bar     (under Form Controls)  4) Place Scroll Bar  5) Right-click scroll bar ~ Format Control...  6) Current Value set to 1     Minimum value set to 1     Maximum value set to 100     Cell Link to $J$2  7) OK  8) Place cursor to F4  9) =INDEX(A2:A$110,$J$2)  10) Drag cell F4 across until I4  11) Drag cell again down 10 rows   Mini Scroll Bar Widget,how to create a vertical scroll bar in excel,excel scrolling table,how to add scroll bar in excel sheet,how to fix scrolling in excel,how to adjust scroll bar in excel,How to Create a Scroll Bar in Excel,

Transcript

00:00Let me show you how you can create this mini preview scroller widget here.

00:04So first thing you have to do is copy the header.

00:06I'm going to select this header here.

00:07Control C to copy.

00:09And maybe I'm going to put it at cell F3 like this.

00:13Just copy paste.

00:14Control C to copy.

00:15Control V to paste.

00:16Next, you're going to go to developer tab.

00:18If your developer tab is not available, click anywhere on the ribbon.

00:21Right click anywhere.

00:23Customize the ribbon.

00:24In here, you're going to select customize ribbon.

00:27And make sure there's a check next to developer and click OK.

00:30Once that's done, the developer tab will be available.

00:33And then you're going to click on insert here.

00:35And then under form control, you're going to select this scroll bar widget here.

00:40And then just going to place it somewhere around like that.

00:44Or however long you want it.

00:45Then once that's done, click anywhere on the cell.

00:48Right click on the widget.

00:50And you're going to be selecting format control like this.

00:52On this pop up here for format control, let's set current value to 1.

00:57Minimum value to 1.

00:59And cell link here.

01:00You're going to put it here.

01:03Like J2.

01:03Let me show you what it does.

01:04And click OK.

01:05So click anywhere outside in the cell.

01:07And if you start to move your scroll bar, you can see J2 value changing accordingly.

01:13That's all we want.

01:14So now you're going to click cell right below the name, which is say F4 for my example here.

01:19And use this formula.

01:20Once that's done, hit enter.

01:23And then click the cell on F4 and drag it right across all the way up to the edge like that.

01:30Once that's done, select that row again and drag all the way down to however many rows you want.

01:36So now if you were to play with your scroll bar, you can see that the table scrolls as well.

Mini Scroll Bar Widget - Excel Tips and Tricks

Category

Transcript

Recommended