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.