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