Filter in Excel Archives

Excel AutoFilter – A Complete Guide

Jun 9, 2024

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

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

May 8, 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 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 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)

Jun 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 ...

How to Filter Horizontal Data in Excel (3 Methods)

How to Remove Filter in Excel (5 Easy & Quick Ways)

May 19, 2024

For the purpose of demonstrating how to remove Filter in Excel, we'll use a sample dataset of a particular salesperson’s sales information, ...

How to Remove Filter in Excel (5 Easy & Quick Ways)

How To Search Multiple Items in Excel Filter (2 Ways)

Apr 25, 2024

We have a simple table having a few random Persons from different Countries and their respective Favorite Sports and Favorite Player. We ...

How To Search Multiple Items in Excel Filter (2 Ways)

How to Apply Multiple Filters in Excel: 6 Methods

Apr 16, 2024

Before going to the steps, consider the following dataset. Here, the Names of 15 Sites are given along with their Category. Furthermore, the Visits ...

How to Apply Multiple Filters in Excel: 6 Methods

How to Filter with Multiple Criteria in Excel (4 Easy Ways)

Jun 27, 2024

Excel FILTER Function: Overview We have the years, the host countries, the champion countries, and the runners-up countries of all the FIFA World ...