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.
Comments