support.microsoft.com
Create a Drop-down List
Microsoft guide to building Excel drop-down lists with data validation.
- Sites
- Free
What it is
Restricting cell entries to an approved list improves consistency and prevents typos in shared workbooks. This official Microsoft page walks through every method for setting up drop-down lists—from a simple range of values to dynamic named ranges and table-based sources—and explains how to configure error messages when someone enters something outside the allowed options.
At a glance
- Source
- support.microsoft.com
- Category
- Official Microsoft
- Cost
- Free
