You can add or delete items from your drop-down list regardless of how you created it. Giving drop-down values manually and using data validation. Love this model and want to build something that may be able to handle up to 76 columns of criteria!! You can do this by placing a Wingdings 3 character in the cell to the right. Create scroll in the classical way. On the Settings tab, click in the Source box. Create a Custom Drop-down List with a Nested IF Statement in Excel. Thanks. Click the Data Validation button in the Data tab. on main sheet I have drop down on cell D6 with values that match the values in row 8 on data sheet. Click Insert and then under the ActiveX Controls. For my example I put them into range F1:F3 of the same worksheet. In this tutorial, I will show you how to create a drop-down filter in Excel so that you can extract data based on the selection from the drop-down. AHHHH excellent, I was missing the extraction change in J4. For more information about how to protect a worksheet, see Lock cells to protect them. 456 1 A drop-down list in excel is a pre-defined list of inputs that allows users to select an option. Save my name, email, and website in this browser for the next time I comment. Assign a name for a range of values and enter the name in the Source: field. We select and review products independently. When we click on OK, we may have a drop-down in cell B2. Thanks for commenting. =IFERROR(SMALL($Q$2:$Q$1048,ROWS($Q$2:Q2)),). So for example in your tutorial. Highlight the range for the drop-down list. error. Now you just need to extract all data from rows that have True. 3. For example I want to Learn Excel in Excel A complete Excel tutorial based entirely inside an Excel spreadsheet. However, this will not update the named range to include the additional item. To run macros by clicking command button is a common task in Excel, but, have you ever tried to execute the macro codes based on the value which is selected from drop down list? //