Since 元 is linked to scroll bar value, when the scrollbar value becomes 1, the formula refers to the first state name. The OFFSET formula uses cell C3 as the reference cell and offsets it by the values specified by cell 元. Now you are all set with a Scroll Bar in Excel. Note that this OFFSET formula is dependent on cell 元, which is linked to the scroll bar.
#No scroll bar in excel download
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).
#No scroll bar in excel how to
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.