Enable the Developer Menu The option to add a drop-down list is located in ...

The best practice is to create a separate worksheet for your drop-down list. To create a new tab, click the "+" icon next to the last tab in your spreadsheet. Double click the tab to rename it.