Skip to main content

Excel Tips: Data > Filter

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?