Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name).

How to create drop down list in excel and add color. Select one or more cells where we want the dropdown list to appear. Step 2 now click the new. Web to take user input, we will first create the dropdown list as follows:

Web first, select the cell where you want to add the dropdown list. You can add or delete items from your drop. Select the cell navigate to data and click on data validation.

Web it is time to learn how to add a dropdown in excel 2019 using very simple techniques that you will find online. Click on data validation this opens up the data.