How to add dropdown list in excel?

There are a lot of benefits to drop down listings in Excel. First of all, the user can control the data that enters the cell and defines a range for them. For example, when it comes to the age of a number of consumers, we can put the 12-70 range on the relevant tuberculosis. Other example is to set two options for men and women to write gender. So that the information importer is selected only from the male and female. This not only simplifies the input data, but also speeds up data entry into the software. In this article you learn how to add dropdown list in excel.

Step1: To do this, first in a sheet, enter the values you want to put in a list in the same column.

How to add dropdown list in excel?

Be sure to enter the order as you would like it to be displayed in the drop-down list.
Step2: Then, in the new sheet, select the cell you want, and from the data tab, select the data validation to open the corresponding window.

How to add dropdown list in excel?

Step3: To create a drop-down list of information, place the Allow on the list, and then click on the source part.

How to add dropdown list in excel?

Step4: Then, while the window is open, select the button below source and enter the sheet where you entered your table and click on the “ok” button as shown below.

How to add dropdown list in excel?

So when you enter the desired sheet, the information in your selected cell is listed as Dropdown.

Good job! You learned how to add dropdown list in excel.

How to add dropdown list in excel?
4.4 (88.57%) 14 vote[s]

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *