loginsax.blogg.se - How to hide horizontal scrollbar in excel for mac

Go to Developer Tab –> Insert –> Scroll Bar (Form Control).

For the purpose of this post, I have used census 2001 data of 28 Indian States with its Area and Population.

The first step is to get your data in place.

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.Ĭlick here to download the example file Steps to Create a Scroll Bar in Excel Creating a Scroll Bar in Excelįor the purpose of this tutorial, I have taken the data for 28 states in India, along with each state’s area and population ( census 2001). You will also learn how to link a dataset to this dynamic scroll bar, such that when a user changes the scroll bar, the data accordingly changes. In this step-by-step tutorial, I will show you how to create a scroll bar in excel. It’s a great tool to use in an Excel Dashboard where you have to show a lot of data in a limited space. Watch Video – Creating a Scroll Bar in ExcelĪ Scroll Bar in Excel is what you need when you have a huge dataset and you don’t want it to hijack your entire screen’s real estate.