Advanced filter MS Excel

Advanced filter option in MS Excel allows to fast filter data in your worksheet. Option available under Advanced filter are Criteria range and list range. Optionally you have output range also.

You can combine multiple column filter with criteria range and list range includes those headings and values which are to be used for filtering.

This Guide applies MS Excel 2007 onwards


  1. Here we are using region wise sales data. Leaving few rows after data write Criteria for Filtration of data.
  2. Select range of Data.
  3. Click on data tab. Select advanced filter
  4. In advanced filter window provide List range and Criteria range. Click OK data is filtered
    Click here to Download Sample worksheet