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.