In the example shown above, data validation is used to provide a dropdown menu with four choices: Red, Blue, Green, and Purple. The validation is applied to the range B5:B16, and the dropdown menu appears when any cell in this range is selected:

For a detailed overview of the data validation, see our Excel Data Validation Guide. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.