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.

Create a Dynamic Drop Down List - Excel on Mac