Create a drop-down list in Excel from another worksheet – Knowligent
Create a drop-down list in Excel from another worksheet

Create a drop-down list in Excel from another worksheet

Home › How to, Tech › Create a drop-down list in Excel from another worksheet
Summary by Lifewire • Unknown Source on Youtube • Published 13 years ago

This article explains how to create a drop-down list in Excel that pulls data from another worksheet. This allows you to enter data into a specific cell on a worksheet from a preset list of items. Instructions apply to Excel 2019, 2016, 2013, and 2010, and Excel for Mac 2019, 2016, and 2011.

In this example, the dropdown menu is on Sheet1 and the data is on Sheet2. Add another sheet in Excel if you don't have one already.

Open Sheet1 and type Cookie Type: in cell D1.

Open Sheet2. In cells A1 through A4, type: Gingerbread, Lemon, Oatmeal Raisin, and Chocolate Chip.