How to Create a Drop down List in Excel Mac?
Posted in mac | 2022-03-22
Create a Drop-down List
In a new worksheet, type the entries you want to appear in your drop-down list.
Select the cell in the worksheet where you want the drop-down list.
Go to the Data tab on the Ribbon, then Data Validation.
On the Settings tab, in the Allow box, click List.
How do you Add a Drop-down List in Excel?
Select the cells that you want to contain the lists.
On the ribbon, click DATA > Data Validation.
In the dialog, set Allow to List.
Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.