QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Filter Data in Excel?

By Neha T Leave a Comment

Dealing with the large scale of data sometimes, it becomes very challenging for us to focus on some specific set of data or the data you are interested in. Well, Excel provides us with the facility to Filter data to narrow down the large scale of data which eases us to study the data of our interest.

In this section, we will discuss the method of adding the filter to the data. Further, we will discuss the steps to filter data and will also explore the steps to apply text filters or number filters. We will talk about applying a filter to multiple columns and finally, we will discuss the method to clear filter and remove the filter.

  1. Add/Create Filter
  2. Apply Filter
  3. Filter Number & Text
  4. Filter Multiple Columns
  5. Clear Filter
  6. Remove Filter

Steps to Filter Data in Excel 2016:

Add Filter

Step 1: Select a cell in the range where your data is placed to which you want to add a filter.

Filter in Excel - 1

Step 2: In the Data tab under the Sort & Filter group you have a Filter option click that filter icon.

Filter in Excel - 2

The filter will get added to the header of every column as you can see in the image below.

Filter in Excel - 3

Filter Data

Step 1: Select a drop-down button of the filter which will display a window. At the bottom of the window, you can check the data in which you are interested and uncheck the data in which you are not interested. And click OK.

Filter in Excel - 4

In the image below, you can observe that only the filtered data is being displayed and the rest of the data got hidden. This is temporary hiding only. So, it becomes easy to study a specific set of data.

You can see that the entire row containing the filtered data is displayed.

Filter in Excel - 5

Filter Text and Number

Text Filters

Step1: Click the drop-down button of the filter which has all text entries and the window displayed will show an option of Text Filters which further provide some option for filtering. Like, you can filter the text, which is equal to some text (provided by the user) or not equal to some text or which begins with or ends with, which contains or does not contains the provided data.

Filter in Excel - 6

You can even customize your filtration as you can see in the image below.

Filter in Excel - 7

I want to filter only those text which is equal to Davis Clawson or Fred and the entire row containing this data would be displayed.

Filter in Excel - 8

Number Filters

Step 1: Click the drop-down button of the filter having number entries only. The displayed window will show an option of Number Filters which further provides the option of filtering the number equal to provided number or numbers which is greater than/less than, between, above average or below average the provided number.

Filter in Excel - 9

You can even customize the filtration. Like I want to filter only those staff whose sales are less than 212.

Filter in Excel - 10

As you can observe in the image below, data of only those staff is displayed whose sales are below 212.

Filter in Excel - 11

Filter Multiple Columns

To apply a filter to multiple columns you just have to apply filtration to the specific columns separately. As in the image below you can observe that I have applied the filter to Staff and Sales individually.

Filter in Excel - 12

Clear Filter

You can clear the filter of any data only if you have applied a filter to it earlier. Like, in the image below, you can see that I have applied the filter to Sales sometime earlier. Now, if you click the drop-down button of the applied filter, the displayed window will show the option of Clear Filter From “XYZ”.

As you will click this option the filter applied to the particular column will get cleared.

Filter in Excel - 13

Remove Filter

To remove the filter over entire data just click on any cell in the range of data to which you have applied filter. Now, click on the Filter in the Sort & Filter group of Data tab.

Filter in Excel - 14

So, this was all about the steps of adding or removing the filter. We have also learned to apply the filter. This eases you work while working with a large scale of data. Hope the content is useful. Keep reading.

You Might Also Like:

Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016? how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? How to create a filter to sort emails and apply label in Gmail delete blank row feature imageHow to Delete Blank Rows in Excel 2016? Graph in Excel - featured ImageHow to Create a Graph in Excel? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel? Pie Chart in Excel featured ImageHow Create a Pie Chart in Excel? Create Pivot Table in Excel feature imageHow to Create a Pivot Table in Excel?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Cancel a Train Ticket through IRCTC
  • How to Delete Microsoft Account in Windows 10
  • How to install Adobe pdf reader and Adobe flash player in Ubuntu 14.04
  • How to Map a Network Drive in Windows 10?
  • How to allow and block Pop-ups in Mozilla Firefox?

Copyright © 2023 · QueHow · Contact Us