Practice free

Data validation in Excel

Draft. The steps on this page have not been checked in desktop Excel yet.

Data validation limits what a cell will accept. Its most common use is a drop-down list.

What data validation does

A validation rule sits on a cell and checks what is typed into it.

The tasks below each cover one job in full.

Drop-down lists