Filter in Excel

Excel AutoFilter – A Complete Guide

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)

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 Filter by List in Another Sheet in Excel – 2 Methods

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 Date Range in Excel (5 Easy Methods)

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 Add Filter in Excel (4 Simple Methods)

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 Filter Unique Values in Excel (8 Easy Ways)

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

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

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

How to Use Text Filter in Excel (5 Methods)

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

How to Perform Custom Filter in Excel (5 Ways)

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 Filter Horizontal Data in Excel (3 Methods)

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 Remove Filter in Excel (5 Easy & Quick Ways)

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 Search Multiple Items in Excel Filter (2 Ways)

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

How to Apply Multiple Filters in Excel: 6 Methods

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 Filter with Multiple Criteria in Excel (4 Easy Ways)

Today I will be showing you how Excel filter multiple criteria of some matching data using the FILTER function of Excel. Before going to the main ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo