Microsoft Office Tutorials and References
In Depth Information
Working with Range Names
3. On the Settings tab, open the Allow
dropdown menu and choose which type of
validation you want to apply.
4. If needed, open the Data drop-down menu to
refine your validation criteria. If you entered
criteria in the Data box, you may also need to
specify the requirements in the Minimum
and Maximum boxes.
Figure 1-29
The input message is displayed whenever
the cell is selected.
5. If you choose List in the Allow drop-down
menu, you have the option of entering all
of the values for the list in a named range
somewhere else in your spreadsheet. Make
sure the In-cell drop-down option on the
Settings tab is checked so that Excel will
display the list of acceptable data entry items
in the cell when users select that cell.
Excel displays a default error message when
data entered into a cell cannot be validated.
You can specify the text on the message to
remind users exactly what the rules are for a
particular cell. From the Error Alert tab (see
Figure 1-30), type a title for the message in
the Title box, and type your message in the
Error Message box.
6. Consider adding a message to alert users of
the data validation requirements before they
begin entering data. On the Input Message
tab, type a message title in the Title box and
type your message in the Input Message box.
The users will see a pop-up message with a
bold text title, shown in Figure 1-29, as soon
as the cell has been selected.
Figure 1-30
The Error Alert tab on the Data Validation dialog box.
Search JabSto ::

Custom Search