Filtering is a quick and easy way to find and work with a subset in a list. Filters shows only those records that contain a certain value, or that meet a set of search condition. Filters does not rearrange a list but temporarily hides rows.
Data Query using Autofilter
To display an entire subset of the list, the Data | Filter | autofilter command handles fast but simple inquires. To use this command, the data list must contain a header row with column names or field names.
Let’s see an example where we will filter those records whose salary is greater than 8000 and less than or equal to 15000.
Step 1 : 
· Select cell B4 and from Data menu, choose filter | Autofilter. 
· Filtering arrow buttons appear next to column labels.

(Figure 5.6)

Step 2 : 
· Click on the filter arrow in cell C4
Besides different values that are in column, the column list shows four additional options. As:
· All Shows all records
· Custom allows the entry upto two criteria for the particular column.
· Blanks Shows all records with no entry in particular column.
· Non-Blanks Shows all records with an entry in the particular column.
Step 3 :
 Select Custom. Custom Autofilter dialogue box opens.

(Figure 5.7)

Step 4: 
In the top operator box, select ”>” us greater then and in the criteria box on right type 8000.
Step 5: 
Click on the And option button
Step 6: 
Click the down arrow button in lower operator box, and then select “<”.(is less than or equal to). 
Step 7:
 Click the down arrow next to lower criteria box and select 15000.
Step 8: 
Choose OK.
The data is filtered to show the list below where salery is greater than 8000 and less than or equal to 15000.

 
(Figure 5.8)

Turning Off Filter
· From the Data menu, choose Filter and then choose Show all.
· From Data menu, choose Filter and then choose Autofilter. The filter arrows on the column label disappear.