As such, you must control the data other people enter. That’s when you need Data Validation. Microsoft Excel makes this job simple. How to use Data Validation for Excel Cells ...

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Figure A We’ll add a data validation control to this sheet. Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.

You can do the same thing with a formula instead of with literal dates. To do so, select C4 and launch the Data Validation dialog as you’ve done before. Then, do the following: ...

Go to Data on the Ribbon, and in the Data Tools group, choose Data Validation. The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole ...

I've got an Excel 97 worksheet in which I need to validate some cells. No problem, I'll just use Data->Validate, right? Wrong. The built in validation works well enough as long as the user doesn't ...