To create a drop-down list in Excel, open two blank worksheets. One will include the data for your drop-down list and the other will contain the drop-down. Enter your data, and then enter the topic the list applies to in the drop-down list document. To link them, create two named ranges (one for the list items and one in the workbook where the list is).