Filter in Excel Archives

Excel AutoFilter – A Complete Guide

Aug 2, 2024

This is an overview. Download Practice Workbook Download this file to practice. Excel AutoFilter.xlsx How to Enable the ...

Filter Data in Excel

Nov 11, 2025

Filter Data in Excel: Knowledge Hub Filter Data in Excel Using Formula How to Filter Cells with Formulas in Excel How to Filter Email ...

Excel Filter Not Working

Nov 11, 2025

Excel Filter Not Working: Knowledge Hub Excel Filter Not Working After Certain Row Excel Not Filtering Entire Column Excel Filter ...

How to Hide Filter Buttons in Excel

Nov 11, 2025

We often use Excel to maintain databases in our day-to-day life. In some cases, we need to filter our data based on specific conditions. This can be ...

How to Convert Text Filter to Date Filter in Excel (3 Examples)

Jun 13, 2024

The basic method to convert a text filter to a date filter in Excel is simple - just disable the text filter first, then move on to work with the ...

How to Convert Text Filter to Date Filter in Excel (3 Examples)

How to Filter by List in Another Sheet in Excel – 2 Methods

Aug 4, 2024

This is the sample dataset. and a list for filtering in the List for Filter sheet. Method 1 - Filter by List in Another Sheet ...

How to Filter by List in Another Sheet in Excel – 2 Methods

How to Use Filter in Protected Excel Sheet (With Easy Steps)

Nov 11, 2025

This article illustrates how you can allow people to use filter in your protected Excel sheet. You may need to do this to create a user-friendly ...

How to Use Filter in Protected Excel Sheet (With Easy Steps)

How to Filter Date Range in Excel (5 Easy Methods)

Jun 24, 2024

We'll consider the sample dataset that contains the sales quantity of some electronic products in a shop in January, February, and March. We'll ...

How to Filter Date Range in Excel (5 Easy Methods)

How to Filter by Color in Excel (2 Examples)

Nov 11, 2025

In financial big data analysis, you could find that applying a filter to your analysis helps you examine your data more effectively. When data is ...

How to Filter by Color in Excel (2 Examples)

How to Add Filter in Excel (4 Simple Methods)

Apr 29, 2024

Consider the following data as a product price list. We have added a filter to the data. The drop-down icons at the right-bottom corners of the ...

How to Add Filter in Excel (4 Simple Methods)

How to Filter Unique Values in Excel (8 Easy Ways)

Apr 29, 2024

Let’s say we have three simple columns in an Excel dataset containing Order Date, Category, and Product information. We want the unique ordered ...

How to Filter Unique Values in Excel (8 Easy Ways)

Shortcuts for Filtering Data in Excel (3 Methods with Examples)

May 18, 2024

Method 1 - Use the Filter Shortcut Option Under the Data Tab to Filter Data Suppose you have the following dataset. Steps: Select any ...

Shortcuts for Filtering Data in Excel (3 Methods with Examples)

How to Use Text Filter in Excel (5 Methods)

Jul 27, 2024

Dataset Overview Let’s consider a scenario where we have an Excel worksheet containing information about products sold by a company to customers. ...

How to Use Text Filter in Excel (5 Methods)

How to Perform Custom Filter in Excel (5 Ways)

May 20, 2024

We will use the sample dataset provided below to perform our custom filter. Method 1 - Filter Value Based on Number in Excel Steps: ...

How to Perform Custom Filter in Excel (5 Ways)

How to Filter Horizontal Data in Excel (3 Methods)

May 4, 2024

The sample dataset contains sales data for 8 products that fall into 3 different categories. We will discuss 3 suitable methods to filter this ...