Creating Validation Rules in Excel




You can make Excel data entry more efficient by setting up data entry cells to accept only certain values. To do this, you can set up a cell with data validation criteria that specify the allowed value or values. Excel also lets you tell the user what to enter by defining an input message that appears when the user selects the cell.