Log in
x
or
x
x
Register
x

or

Excel Tips: Data > Filter

Auto Filter

How to autofilter rows based on cell value in Excel?

How to automatically reapply auto-filter when data changes in Excel?

How to display / show auto filter criteria in Excel?

Number Filter

How to filter numbers end with a specific number in Excel?

How to filter only integers (whole numbers) or decimal numbers in Excel?

How to filter top 10 items in pivot table?

How to quickly filter or hide even or odd numbers in Excel?

Date Filter

How to filter all date cells before or after today in Excel?

How to filter by month in a pivot chart in Excel?

How to filter data by quarter in Excel?

How to filter date range in an Excel Pivot Table?

How to filter dates between two specific dates in Excel?

How to filter dates by month with ignoring year in Excel?

How to filter weekdays and weekend days in Excel?

Text Filter

How to filter cells with question mark in Excel?

How to filter column data by a certain prefix in Excel?

How to filter comma separated data in Excel?

How to filter data based on substring in Excel?

How to filter data begins with number or letter in Excel?

How to filter data by containing asterisk or other special characters in Excel?

How to filter exact text in Excel?

How to filter values by first letter or last character in Excel?

Filter by Formatting

How to filter cells by bold characters in Excel?

How to filter data based on the font size in Excel?

How to filter data by multiple colors in Excel?

How to filter or select cells by cell color in Excel?

How to filter rows based on cell color in Google sheet?

How to quickly find and filter cells by italics format in Excel?

How to sort or filter data by strikethrough in Excel?

Filter by Custom List

How to filter a worksheet based on a range of cells in another worksheet in Excel?

How to filter rows based on a list selection in another sheet?

How to filter rows by list of values in Excel?

Filter by Multiple Criteria

How to filter data by multiple conditions in Google sheets?

How to filter data by multiple criteria in Excel?

How to filter with multiple criteria or wildcard in Excel?

Clear Filter

How to clear filter cache (old items) from Pivot Table in Excel?

How to clear filters from all worksheets in active workbook in Excel?

How to clear filters when opening, saving or closing workbook in Excel?

Others

Filter Unique Values

How to filter or select unique records from selected range in Excel?

How to filter out duplicates and keep unique values in Excel?

Filter Scope

How to apply same filter to multiple sheets In Excel?

How to apply the same filter to multiple pivot tables?

Others

How to do instant filtered search as you type in a cell in Excel?

How to filter a list and delete the rest hidden or visible rows in Excel?

How to filter all cells with line break or carriage return in Excel?

How to filter all related data from merged cells in Excel?

How to filter cells by length of text in Excel?

How to filter cells with case sensitive in Excel?

How to filter cells with comments in Excel?

How to filter cells with formulas in Excel?

How to filter data based on checkbox in Excel?

How to filter data based on drop down list in Google sheet?

How to filter data exclude bottom total row in Excel?

How to filter data from drop down list selection in Excel?

How to filter data from one worksheet to another dynamically in Excel?

How to filter data include blank rows in Excel?

How to filter data just by clicking cell content in Excel?

How to filter data with hyperlinks in Excel?

How to filter data with pictures in Excel?

How to filter every other row (even /odd rows) in Excel?

How to filter multiple columns based on single criteria in Excel?

How to filter multiple columns simultaneously in Excel?

How to filter Pivot table based on a specific cell value in Excel?

How to hide filter arrows/buttons while filtering in Excel?

How to not ignore blank rows when filtering in Excel?

How to reverse (delete) filtered rows in Excel?

How to save custom filter criteria/view in Excel?

How to update advanced filter result automatically in Excel?