Microsoft Office Tutorials and References
In Depth Information
Setting data validation rules
2
Click the arrow on the lower-right corner of cell E1; deselect England, France, and
Hungary, and then click OK.
Deselect the categories you want to hide.
Excel displays only the movies with directors from the United States and a i lter icon ( )
in place of the arrow in the column you i ltered.
To remove the i lter, click the Filter icon and select Clear Filter From. Excel displays all records in
the column.
3 Choose File > Save, and then choose File > Close.
Setting data validation rules
You can apply validation criteria to data entry cells so that they accept only certain values.
You can also display a message to users when they enter data into the cell. This can prevent
them from making incorrect entries in the worksheet.
To open the i le you need for this lesson:
1
Choose File > Open and navigate to the Excel07lessons folder.
2
Click excel0702 and then click Open.
3
Select File > Save As. Excel displays the Save As dialog box.
4
In the Save As text box, type excel0702_done and then click Save.
Search JabSto ::




Custom Search