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.
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.
Step3: To create a drop-down list of information, place the Allow on the list, and then click on the source part.
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.
So when you enter the desired sheet, the information in your selected cell is listed as Dropdown.