Similarly, you can enter the items in a single row, such as A1:D1. Create the data validation list in cells A1:A4.To add the drop down list in our example to an Excel sheet, do the following: You can work with your own data or download the demonstration. Figure A shows a simple drop down list in an Excel sheet. You need only two things: A list and a data entry cell.
In this Excel tip, we'll show you a quick and easy way to create a dropdown list or drop down menu using the spreadsheet application's Data Validation feature. Using a drop down menu in web forms, surveys, or polls can limit the entry choices for a selected cell, speeding data entry and reducing data entry error. An Excel drop down list or dropdown menu can make it easier for the average Microsoft Excel user to enter data on a worksheet or workbook.
