contents of the table . . , follow the following two steps Step : Place cell pointer anywhere in the table Step : Click Auto Filter icon available on the “Standard tools bar” (or) Click Data → Filter → Auto Filter In the above table, if you want to view only the students belongs to the Group code ; Click the dropdown list box’s drop arrow (a tiny triangle) to get the filter criteria. (Refer Figure .
) Chapter Select group code from the list The spreadsheet displays only the student’s details those who are studing in group code (Refer Figure . ) and the remaining details are only hidden. Figure . Filtered details Figure .
Standard Filter dialog box Removing Auto Filter: To remove auto filter, click “Auto filter” icon once again . The original table is displayed without filter. ( ) Standard Filter: Auto filter is used only for single criteria on a data, whereas the Standard filter is used for multiple critieria to filter. Step : Select Data → Filter → Standard Filter.
Chapter Now, the entire data is selected and "Standard Filter" dialog box dispalys as shown in Figure . . Step : Select the column heading from the “Filed name” list box for first criteria. Select conditional opeator such as >, <, = etc., from “Condition” list box.
Type or select the value of critera in the “Value” box. Step : Select the one of the logical operator (And / Or) from “Operator” list box to fix second criteria. Follow the step , for the next criteria. Step : Click “OK” to finish.
Example for Standard filter: If you want to filter the records of “BC” students of group code from the table . . Step : Select Data → Filter → Standard Filter Now, “Standard Filter” dialog box appears as in Figure . Step : In “Standard Filter” dialog box, select the first criteria; Select Field name as Group code Select Condition as = Type or select Value as Step : To select the second