Type a name for the values of your drop-down list and then click 'OK'. They should be in a single column or row without any blank cells (for easy to use, it is recommended to sort your values).
On a new worksheet, type the values that you want to appear in your drop-down list.
