Using AutoFilter
AutoFilter enables you to specify criteria and then Excel temporarily hides those rows in
the database that do not meet the criteria. For example, we can find the list of those employees
who work in the personnel department.
Make sure that some cell in the database is selected. Then use the Data, Filter command.
Excel displays a submenu that contains three commands. Auto Filter, Show All and Advanced
Filter.
Click AutoFilter and Excel displays drop- down arrows on the right side of all field name in the
header row. These arrows enable you to display only those rows in a database list that contain a
certain value or that meet a set of criteria. To specify criteria on a particular field, you need to
click the corresponding drop-down arrow.
Click the drop-down arrow on the right side of Department field, it displays a drop-down list. This
list is used to apply a filter on the selected field.
Since we want to display only those records that contain 'personnel' in the department field,
click personnel' in the Drop-down list. Excel hides those records that do not have
'Personnel' in the department field.
Removing Filter
Remove the filter applied on the Department field's drop-down arrow to display the
drop-down list. Then click '(All)' and excel displays all records in the database. To clear the filter,
you can also use the Data, Filter, and show All command from the menu.
Applying Filter on Multiple Fields
If we want to display records for only those employees who are 'Assistant' and who
draw a salary of more than 6000.
Click the drop-down arrow of the Designation Field. Then choose 'Assistant' From the
drop-down list displayed by Excel.
Excel applies the filter-designation equals to Assistant on the database.
Click the drop-down arrows of the salary field.Excel displays the drop-down list for the Salary
field. To specify a condition such as salary >6000,we have to choose '(Custom )'.
Click Custom in the drop-down list.
Excel displays Custom AutoFilter dialog box.
Click the drop-down Arrow for the salary field and then choose 'is greater than 'from the
drop-down list.
Click the mouse-pointer in the box on the right side of the Salary comparison operator box. Click
the OK button and Excel applies the new filter condition (salary>6000) on the database that
already has one condition (Designation =Assistant) applied on it. Excel displays the qualifying
records on the screen.
Removing AutoFilter
AutoFilter enables you to specify criteria and then Excel temporarily hides those rows in
the database that do not meet the criteria. For example, we can find the list of those employees
who work in the personnel department.
Make sure that some cell in the database is selected. Then use the Data, Filter command.
Excel displays a submenu that contains three commands. Auto Filter, Show All and Advanced
Filter.
Click AutoFilter and Excel displays drop- down arrows on the right side of all field name in the
header row. These arrows enable you to display only those rows in a database list that contain a
certain value or that meet a set of criteria. To specify criteria on a particular field, you need to
click the corresponding drop-down arrow.
Click the drop-down arrow on the right side of Department field, it displays a drop-down list. This
list is used to apply a filter on the selected field.
Since we want to display only those records that contain 'personnel' in the department field,
click personnel' in the Drop-down list. Excel hides those records that do not have
'Personnel' in the department field.
Removing Filter
Remove the filter applied on the Department field's drop-down arrow to display the
drop-down list. Then click '(All)' and excel displays all records in the database. To clear the filter,
you can also use the Data, Filter, and show All command from the menu.
Applying Filter on Multiple Fields
If we want to display records for only those employees who are 'Assistant' and who
draw a salary of more than 6000.
Click the drop-down arrow of the Designation Field. Then choose 'Assistant' From the
drop-down list displayed by Excel.
Excel applies the filter-designation equals to Assistant on the database.
Click the drop-down arrows of the salary field.Excel displays the drop-down list for the Salary
field. To specify a condition such as salary >6000,we have to choose '(Custom )'.
Click Custom in the drop-down list.
Excel displays Custom AutoFilter dialog box.
Click the drop-down Arrow for the salary field and then choose 'is greater than 'from the
drop-down list.
Click the mouse-pointer in the box on the right side of the Salary comparison operator box. Click
the OK button and Excel applies the new filter condition (salary>6000) on the database that
already has one condition (Designation =Assistant) applied on it. Excel displays the qualifying
records on the screen.
Removing AutoFilter
