When applied, the Data Validation function serves to restrict data that can be entered in the target cell, requiring users to select a value from a list of pre-determined inputs.
#How to make a drop down list in excel 2016 how to#
And also you can follow us on Twitter and Facebook. This article will teach you how to create drop-down lists in Microsoft Excel using a feature called Data Validation.
If you liked our blogs, share it with your friends on Facebook. You can create a dropdown list in google sheets using the same method. Repeat the process for all the options like Green and Blue and your list will be shown like in below snapshot.ĭrop down list and Conditional formatting tools are very useful in Excel 2016, to view your data in a particular format manner. On the Data tab, in the Data Tools group, click Data Validation. I would prefer to select a date from a drop-down box cell AK1 via DataValidation and have that date/cell control my date slicer Cal Year. In the data validation dialog box, within the settings tab, select List. I have a sheet Dashboard with a variety of slicers and space is a premium. This will open the data validation dialog box. The video covers naming lists, data validation and the INDIRECT function features of Excel you will need to know about to achieve the cascade effect. On the second sheet, create the following named ranges. Here are the steps to create a dependent drop down list in Excel: Select the cell where you want the first (main) drop down list. This video shows you how to create cascading, dependent or multilevel drop down lists in Excel. Select Specific Text option and select the cell for colour as in this case Red. To create these dependent drop-down lists, execute the following steps. Select New rule from the list and a dialog box will appear. Select the option List in Allow and select the source list in Source option and click OK.Ī dropdown list will be created on the cell. We need that the user has to select from this list.Ĭlick Data > Data Validation option in Excel 2016ĭata Validation dialog box appears as shown above. Here is a list of three colours Red, Green and Blue. We will be using Conditional Formatting and Data Validation options.įirst, let’s understand how to make a dropdown list in Excel with an example here In this article, we will learn how to create a Dropdown list with color in Microsoft Excel.ĭrop down list limits the user to choose a value from the list provided instead of adding values in sheet.