@media (max-width: 46rem) { .site-head .nav { display: block; position: static; border: none; box-shadow: none; } .site-head .burger { display: none; } }

#Data validation

Everything tagged Data validation.

1 article

A close-up of a laptop screen showing a spreadsheet cell with an open drop-down selection menu.

SoftwareAugust 23, 2026

How to Make a Drop-Down List in Excel

Learn how to build an Excel drop-down list with Data Validation, using typed items or a cell range, plus how to edit it later and add error alerts.

4 min read