Microsoft Office Tutorials and References
In Depth Information
Validate with a
Excel enables you to restrict the values a user can
enter in a cell. By restricting values, you ensure that
your worksheet entries are valid and that calculations
based on them thereby are valid as well. During
data entry, a validation list forces anyone using your
worksheet to select a value from a drop-down menu
rather than typing it and potentially typing the wrong
information. In this way, validation lists save time
and reduce errors.
To create a validation list, type the values you want
to include into adjacent cells in a column or row. You
may want to name the range. See Task #11 to learn
how to name ranges. After you type your values, use
the Data Validation dialog box to assign values to your
validation list. Then copy and paste your validation list
into the appropriate cells by using the Paste Special
You may want to place your validation list in an
outof-the-way place on your worksheet or on a separate
Click in the cell in which you
want to create a validation list.
Click the Data tab.
Click Data Validation in the Data
l The Data Validation dialog box
Click the Settings tab.
Click here and then select List.
Click and drag to select the valid
entries, or type = followed by
the range name.
Excel creates a validation list in
the cell you selected.