Creating Excel Drop-Down Lists Using Data Validation

Environment

Microsoft Excel

Issue

Need to add a drop-down list to a cell in an Excel spreadsheet.

Resolution

1. Select the cell(s) where you want the drop-down list to appear.
   1. This can be a single cell, a range of cells, or a whole column.
2. Go to the Data tab, then click on Data Validation.
3. On the Settings tab, in the Allow box, select List.
4. In the Source box, type the items you want to appear in the drop-down list, separated by commas, with or without spaces, or select a range of cells on the sheet that contain the items.
5. Click OK to save your drop-down list.

Additional Information

You can also add or remove items from a drop-down list by clicking on the desired cell, then going to Data > Data Validation.

Need additional information or assistance? Contact the ITS Service Center.