Excel Data Validation
Data validation is the fastest way to make a spreadsheet resistant to typos, bad data, and user error. Dropdowns, number ranges, date windows, dependent lists, and custom formulas — all in one tool. This hub links every guide and how-to for mastering it.
What's on this page
Complete Guide
The full pillar covering every validation type, dropdown lists in depth, dependent dropdowns with INDIRECT, custom formula validation, input messages, error alerts, and the patterns that pay off from day one.
How-To Posts
Step-by-step tutorials for specific validation tasks.
Related Clusters
Validation rules that don't break tomorrow
Dependent dropdowns, custom formulas, cross-cell rules — data validation gets tricky fast. Excel Wizard takes your intent ("dropdowns for Region and City where cities depend on region") and builds named ranges, INDIRECT formulas, and validation rules with correct absolute references.
Install Excel Wizard →