![]() Step 5: In cell E2 give heading Years and in cell F2 Amount I linked cell E1 by mentioning $E$1 in the cell link input box. This output will be in the form of numbers which we will help us use scroll bar. Step 4: In cell link mention the cell address where you want scroll bar to give output. This value lets you adjust how many cells it should jump. Page change: If you click somewhere in the scroll bar, it will act as page up or page down command. Incremental change: lets you adjust how many cells scroll bar should jump if you click on arrow buttons. This can serve as the last point of scroll. Maximum value: the maximum value scroll bar can generate. Minimum value: the minimum value scroll bar can generate. This will open up format control dialogue box. Step 3: Right click on the scroll bar > format controls. You can choose to draw it horizontally or vertically. This will change the cursor to plus sign enabling you to draw the scroll bar anywhere in the worksheet. Step 2: Go to developer tab > controls group > insert button drop down > click scroll bar controls. Have a look at the following animation to understand the process of activation. Step 1: First thing you need is to have your developer’s tab to be activated if its not already. Yes! It really is interesting and getting it is not so difficult either. ![]() What I mean is to have something like shown below: Things would be much more easy if we can scroll through the whole range but only a subset of data appears to make things easier to manage and interpret. If Excel ever had a tongue it surely would have told us that eating thousands of rows is as delicious for it as dunking oreos in milk for humans!īut we humans have another issue and that is we easily get tired of scrolling down especially if the list is so long as if it is emerging from the center of the earth.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |