Create a drop-down list

1. Select the cells to have the drop-down, go to the Data tab and choose   Data Validation.

2. For Allow, choose List.

3. For the drop-down Source, type items separate by commas, a range of cells, or a named range.
   For example: Yes,No,Maybe, =$A$2:$A$4, =PriceRange.

4. Select OK. 
   
   For more info, see Create a drop-down list in Excel.

Tip: To add or remove drop-down items, see Edit a drop-down list.

1. Select the cells to have the drop-down, go to the Data tab and choose   Data Validation.

2. For Allow, choose List.

3. For the drop-down Source, type items separate by commas,  a range of cells, or a named range.
   For example: Yes,No,Maybe, =$A$2:$A$4, =PriceRange.

4. Select OK. 
   
   For more info, see Create a drop-down list in Excel.

Tip: To add or remove drop-down items, select the dropdown, repeat step 1, and make changes. 

1. Select the cells to have the drop-down, go to the Data tab  and choose  Data Validation.

2. For Allow, choose List.

3. For the drop-down Source, type items separate by commas, or a range of cells.
   For example: Yes,No,Maybe or =$A$2:$A$4.

4. Select OK. 
   
   For more info, see Create a drop-down list in Excel.

Tip: To add or remove drop-down items, select the dropdown, repeat step 1, and make changes.