Microsoft Office Tutorials and References
In Depth Information
Defining valid sets of values for
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