Improve Your Excel.com
Everything you need to improve your Excel in one place!
Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

Excel Filter


Filtering data in Excel is a very powerful method of querying large lists. The power of Excel Filter goes far beyond the auto filter feature. See the links below to learn more

Excel Filter Tips and Tutorials
  • Changing AutoFilter Drop-Down Arrow Colors


  • Copying the Results of Filtering


  • Extracting Targeted Records from a List


  • Increasing the AutoFilter Drop-Down Limit


  • Limits to Filtering


  • More Than Two Conditions for Custom AutoFiltering


  • Performing Calculations While Filtering


  • Quickly Identifying Applied AutoFilters


  • Removing Duplicates Based on a Partial Match


  • Setting Up Custom AutoFiltering


  • Using AutoFiltering


  • How To Use Excel's AutoFilter


  • AutoFilter


  • Coloring and Filtering Lists According to Criteria


  • Enable AutoFilter functionality for a protected worksheet


  • Filtering


  • Filtering a List into Unique Records Using the COUNTIF Formula


  • Filtering a Range into a List of Unique Records


  • Filtering by More Than Two Criteria


  • Filtering by the Date Field


  • Quick Filtering Using the AutoFilter Icon


  • Saving Filtering Criteria


  • Sort Ascending/Descending While Using AutoFilter


  • Use Excel's Advanced Filter to delete duplicates in a list


    • Want more tips? Subscribe to our Free Newsletter today and we will send them to you.
    Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros