• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Filter in Excel

May 21, 2021 by Andrew Childress
How to filter in Excel

When you’re working with lists of data in a spreadsheet, it’s often useful to filter by certain values. Let’s learn how to filter in Excel.

When you’re working with lists of data in a spreadsheet, it’s often useful to filter by certain values. This is very easy to do, and helps you analyze data faster. Let’s learn how to filter in Microsoft Excel.

How to Filter in Excel

Consider a list of cities and states. Cities are grouped in one column, and states are grouped in an adjacent column. Imagine that you quickly want to generate a list of cities in Florida only. This is where Excel’s filtering features can help.

To filter, begin by clicking into any of the cells in the top row of the list. These are column headers, and they represent what you want to filter the data by.

Then, go to the Home tab on Excel’s ribbon. Over on the right side of the menu bar, you’ll see the Sort & Filter dropdown. Go ahead and click on it, then choose Filter.

Filter Excel

You’ll see dropdown arrows appear in the row that you have selected. To filter by state, click on the dropdown in cell E1. You’ll have some options here. You can specify whether to sort in ascending or descending order, for example.

By default, all variables are selected. Click the box beside Select All, and then click beside the appropriate state that you want to filter by.

Filter in Excel

Your list will transform, showing only Florida cities. Keep in mind, the other data is merely hidden, not deleted.

To remove the filter, simply click on the dropdown again and choose Clear Filter.

How to filter in Excel

You can also turn filters off entirely by returning to the Sort & Filter dropdown, and unchecking Filter.

As you can see, filters are a quick and easy way to sort datasets in Microsoft Excel. Try them any time you need to group values together in an easy-to-read style.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Average in Excel Average in Excel
Next Post: Freeze Columns in Excel Freeze columns Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top