Data entry is quicker and more accurate when you use a drop-down list to limit the entries that people can make in a cell. Let’s see how we can create a Drop-Down Lists in Excel. Let’s assume that we have the employees’ ID and we want to add the department in a drop-down list. The Departments are Product, Sales, Finance and Other.
A) Select the cells that you want to contain the lists:
B) On the ribbon, click the DATA tab, and click Data Validation
C) In the dialog, set Allow to List and Click in Source. In this example, we are using a comma-delimited list. The text or numbers we type in the Source field are separated by commas. Click OK and the cells will have a drop-down list.
