Top Mac Excel Tips - Creating a drop down list - In Tech We Love
Creating a drop down list
Select the column or list of cells you want to use to populate your drop down list. This can be on the same sheet or a different to the one you want to display your drop down list on.
Go to Insert > Name > Define
Add the name you want to use to reference the list, for example mylist & press ‘Ok’
Go to the cell in which you want to display your drop down list.
Go to Data > Validation
In the allow drop down select ‘List’
In source type write = followed by the name you gave your list, for example =mylist
Press ‘Ok’, your drop down list should now appear when you click on the cell you added it to