Create a drop-down list

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less

Select the cells to have the drop-down, go to the Data tab and choose Data Validation.
For Allow, choose List.
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.
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.

Select the cells to have the drop-down, go to the Data tab and choose Data Validation.
For Allow, choose List.
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.
Select OK.

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