This tip is really useful for Excel dashboards or anywhere that space is of a premium on a worksheet or, where your data set is just too large to comfortably display. Let’s look at using a scroll bar to show only 10 records at a time of a data set.

Now, I want to create a data set that displays only 10 states at a time, and when the user changes the scroll bar, the data dynamically changes. Something like this shown below: Click here to download the example file. Steps to Create a Scroll Bar in Exce

Then create a scroll bar besides your data headers, please click Developer > Insert, and select Scroll Bar under Form Controls, then drag the cursor to draw a scroll bar as following screenshots: Note : If your Excel do not show the Developer tab, you