Skip to main content

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?