Here's a clever way to create a scrollable list that makes things so much easier!

Here's a clever way to create a scrollable list in Excel without scrolling the entire sheet. Start with your data and convert it into an Excel table, and give it a name. Now go to the developer tab, insert, and insert a scroll bar and place it beside the table. Right click the scroll bar, choose format control and set the values. Link it to cell B2. That linked cell will control which row of the list starts from. Now in the first cell, enter this formula: =TAKE(DROP(Tb1Directory, $B$2-1), 25). The DROP function skips rows based on the scroll bar value, and the TAKE function returns only the next 25 rows. Now when you move the scroll bar, the employee list scrolls without scrolling the entire sheet. And this technique is especially useful when you want to display other information or charts next to or below the scrollable list. Thanks for watching! Leave a comment with the word "SHORTCUTS" and I'll send you our free guide with over 270 Excel shortcuts!