![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
Try it!
Help people work more efficiently in worksheets by using drop-down lists in cells where they can pick an item from a list you create.
-
Select where you want the drop-down to appear.
-
Select Data > Data Validation.
-
Choose List.
-
Select the Source button.
-
Select items to appear in the drop-down and press Enter.
-
Select OK.
-
Select the drop-down arrow to select items from your drop-down list.