Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Create a drop-down list by selecting a range of cells The most common way to create a drop-down list in Excel with multiple selections is by using a range, which relies on using data from other cells.