How to Establish Data-Validation Rules in Excel 2013

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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.