Microsoft Office Tutorials and References
In Depth Information
Validating data using a list
validating data using a list
When a user enters data into a worksheet cell, you can limit
the type of data they enter and constrain numbers to certain
ranges. You can also limit text entries to a list of values entered
elsewhere in your workbook.
validate data according to a list in a
1 Select the cells that you want to validate.
2 On the Data tab, click the Data Validation button’s down arrow.
3 Click Data Validation.
4 Click the Settings tab.
5 Click the Allow down arrow.
6 Click List.
7 Click the Source box.
8 Select the cells that contain the values that you want in your list.
9 Click OK.
TIP On the Settings tab of the Data Validation dialog box, you
can clear the In-Cell Dropdown check box so that a drop-down
arrow does not appear next to the cell with the available options.