O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Validating Input

Excel's Data Validation command lets you perform validation on entries to set up data validation rules. You can define data that is acceptable for any given cell or range of cells, and input messages or error alerts that display whenever a validated cell is selected. Error alerts can display whenever a validated cell is selected or when a user tries to enter an invalid value. Data Validation only warns you against inputting invalid data—it doesn't stop you from doing so.

Setting Validation Rules

Follow the steps in the next exercise to set up the data validation rules. You are setting rules for the Car data in column B on the Detail sheet.

To Do: Set Validation Rules
1.
Click cell A12 on the Detail sheet. Type New York and press ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required