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

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

We will also show you how to make a colored and nested drop-down list. If you use Microsoft Excel as your preferred analytic tool, you might already be familiar with the concept called conditional ...

Drop-down lists are perfect for several purposes, such as inputting information into a form. Here's how to create a drop-down list using Microsoft Excel on Windows and Mac.