Step 1. Select the cell range with data and right-click, then define the named range.ĭefining the cell ranges for a Google Sheets drop-down list based on another cell range is helpful since it makes it easy to use them in formulas later on. So, I’m going to create a dependent dropdown in cell A10 that will let me select a category, and once I select it, a dropdown list will show up in cell B10 listing all the options in my selected category. For example, the heading or category “Color” has four options: Blue, Red, Green, and White. To show you how to create a dependent drop-down list Google Sheets, I will use the following example of a shirt store with four different headings (categories), namely, Color, Size, Type, and Year.Įach heading has four different options within.
A Step-By-Step Guide to Making a Dependent Drop Down List in Google Sheets Other situations could be if you were looking for books written by a specific author and wanted to know what books the website has that are written by that author. Let’s discuss what a Google Sheets drop down list based on another cell range is and how it helps users write their data in a simple, error-free way.Īs mentioned before, the purpose of a drop-down list is to allow the users to build a drop-down list where when the user selects a category in cell A, they are presented with options in cell B accordingly.Īn example of a situation where this type of drop-down list may be useful is if you are surfing through a website looking for a specific genre of music, you may find it easier if it was divided into different categories and all the songs you like were just one click away, and you would know what songs are available to stream on the site under each genre.
What is a Standard Dependent Dropdown List?
0 kommentar(er)
