Article ID: 2720580 - View products that this article applies to.
Expand all | Collapse all

More information

The Advanced Filter gives you the flexibility to extract your records to another location on the same worksheet or another worksheet in your workbook. It also allows the use of an "OR" statement in your Filters. (Example: Which sales were less than $400 "OR" greater than $600). Excel’s AutoFilter filters things in place and doesn't allow you to do complex filtering. To learn the basics of Advanced Filtering follow the steps below:

Step 4: Set up the Extract Range (The Basics).

Need More Help?

Find out more about Advanced Filtering by reading: Filter by using advanced criteria
Find out more about Criteria Ranges by reading: Examples of complex criteria

You can also get help from the Microsoft Community online, search for more information on Microsoft Support or Windows Help and How To, or learn more about Assisted Support options.


Article ID: 2720580 - Last Review: October 3, 2012 - Revision: 5.0
Applies to
  • Microsoft Excel 2010
consumeroff2010track KB2720580

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from