How to create a nested drop-down list in Excel If you want to obtain data from some existing drop-down menus or cells and display options accordingly in a different cell, here is what you can do.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Click the Lists sheet tab or the tab that contains your list items. Select the list (A1:A4). Click OK, which will return you to the new sheet, where you’ll find a populated list in E4 ( Figure A ).