Creating Validation Rules in Excel

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.

 

 

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips