Microsoft Office Tutorials and References
In Depth Information
Setting data validation rules
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:
Choose File > Open and navigate to the Excel07lessons folder.
Click excel0702 and then click Open.
Select File > Save As. Excel displays the Save As dialog box.
In the Save As text box, type excel0702_done and then click Save.
Search JabSto ::

Custom Search