• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint