Create A Drop-Down List
https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b
In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you’ll have your list items in... Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, then Data Validation.Note: If you can’t click Data Validation, the worksheet might be... On the Settings tab, ...
In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you’ll have your list items in...
Select the cell in the worksheet where you want the drop-down list.
Go to the Data tab on the Ribbon, then Data Validation.Note: If you can’t click Data Validation, the worksheet might be...
On the Settings tab, ...
DA: 55 PA: 85 MOZ Rank: 7