Microsoft Office Tutorials and References
In Depth Information
Setting accurate validation rules can help you and your colleagues avoid entering a
customer’s name in the cell designated to hold the phone number or setting a credit limit
above a certain level. To require a user to enter a numeric value in a cell, display the
Settings page of the Data Validation dialog box, and, depending on your needs, choose
either Whole Number or Decimal from the Allow list.
If you want to set the same validation rule for a group of cells, you can do so by selecting
the cells to which you want to apply the rule (such as a column in which you enter the
credit limit of customers of Consolidated Messenger) and setting the rule by using the Data
Validation dialog box. One important fact you should keep in mind is that, with Excel, you
can create validation rules for cells in which you have already entered data. Excel doesn’t
tell you whether any of those cells contain data that violates your rule at the moment
you create the rule, but you can find out by having Excel circle any worksheet cells
containing data that violates the cell’s validation rule. To do so, display the Data tab and
then, in the Data Tools group, click the Data Validation arrow. On the menu, click the
Circle Invalid Data button to circle cells with invalid data.
Search JabSto ::

Custom Search