In today’s video I demonstrate how to create a scrolling table in Excel using the scrollbar option in your format controls. This is a great way to allow more data in a small space, such as a dashboard. You can see how this will look in the animated gif below:
I use the INDEX function to add this interactivity. If you want to better understand the INDEX function, I did a comprehensive video covering three marketing uses for the INDEX function. (You’ll also find out why I always use the INDEX function over the OFFSET function.)
You can also see how I used a scrollbar to create a scrolling chart.
If you’d like to download the file to follow along, you can get it here. (It’s a Dropbox link, so if your company blocks Dropbox, you may have to wait until you get home.)