Home - Information Services - Get Help - How-to-Guides - Excel 2016 - Populate Cells Using a Drop-Down List

Populate Cells Using a Drop-Down List

1. Create a column that contains the drop-down list values. (This can be on the same worksheet as the cells you want to populate or on a different worksheet within the same workbook.)
   
   
2. Select the cells that you want to populate with a drop-down list.
   
   
3. On the Data tab, click Data Validation.
   
   
4. Click the Allow down arrow and select List.
   
   
5. Click in the Source field.
   
   
6. Select the cells that contain the drop-down list values.
   
   
7. Click OK. When you click one of cells you selected in step 2, a drop-down list should appear.