How to Create and Enter Data in an Access 2013 Form
How to Create Rules for Arriving Messages in Outlook 2013
How to Create Conditional Formatting in Access 2013

How to Establish Data-Validation Rules in Excel 2013

By establishing data-validation rules in Excel 2013, you can greatly decrease the chances of errors being entered, and the rules aren’t particularly hard to set up.


Select the cell or cells that need a rule and then click Data Validation on the Data tab of the Ribbon.

Select the cell or cells that need a rule. You see the Settings tab of the Data Validation dialog box.


On the Allow drop-down list, choose the category of rule you want.

Enter the criteria for the rule. What the criteria is depends on what rule category you’re working in. You can refer to cells in the worksheet by selecting them. To do that, either select them directly or click the Range Selector button and then select them.


On the Input Message tab, enter a title and input message.

You can see a title and input message. The title appears in boldface. Briefly describe what kind of data belongs in the cell or cells you selected.


On the Error Alert tab, choose a style for the symbol in the Message Alert dialog box, enter a title for the dialog box, and enter a warning message.

The title you enter appears across the top of the dialog box, and the message appears beside the symbol.


Click OK.

To remove data-validation rules from cells, select the cells, go to the Data tab, click the Data Validation button, and on the Settings tab of the Data Validation dialog box, click the Clear All button, and click OK.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Share Your Office 2013 Files and Folders
How to Remove the Background from a Graphic Image in Office 2013
How to Adjust Left and Right Paragraph Margins in Word
How to Compare Documents in Word 2013
How to Present a PowerPoint 2013 Presentation Online