Copyright

How to Filter Records and Data in Excel

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: How to Sort Data in Excel

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:01 The Filter Tool
  • 1:23 You Need a Header Row
  • 2:50 How to Run a Filter
  • 4:01 Running Multiple Filters
  • 4:41 Lesson Summary
Save Save Save

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed Speed Audio mode
Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

When you need to find specific information in an Excel spreadsheet, the Filter tool is an easy way to get information fast. This lesson will discuss the Filter tool in Excel and explain how to use the tool to narrow down the data in your worksheet.

The Filter Tool

Some Excel worksheets can have a lot of information. So much so that finding the information you want can be difficult, especially if you have to sort through rows and rows of data. Over the years, I have lead several discussions and classes on the use of data, how to manage it and use it to your advantage. My message is always the same. I tell students that the benefit of any database, catalog of information or list of records is the ability to find what you are looking for and use it. This lesson will explain the Filter tool in Excel. This feature can help you quickly get to the information you need - and only the information you need.

Imagine you are a sales rep and over the years you have tracked all of your contacts, their interests, email address, personal information, phone numbers, etc. You have details of every conversation and correspondence with each contact, including dates and notes. It's well-built and, for all intents and purposes, a well-organized listing of information. It most certainly has value. However, if you can't find what you are looking for, when you need it and use the information to your advantage, what's the point? That's when the Filter tool comes in handy.

You Need a Header Row

Before you can apply a filter to data in an Excel worksheet, your list of information must have a header row. A header row is the row of titles that identify each column. The header row is typically the first row of your spreadsheet. In order to perform a filter, Excel needs to know what type of information is in each column. In order to really explain how this all works, we need an example.

Let's say that you are a highly respected and somewhat wealthy poker player living in Las Vegas. Due to your reputation as a fun-loving, outgoing and generous player and friend, you have amassed quite the following of celebrity friends. Next month you are having a get-together to raise funds for charity. You have decided to hold a poker tournament. You plan to have everyone put up a few bucks (okay - lots of bucks) into the pot and the money will go to the winner's choice of charity organization.

Looking at the spreadsheet of celebrity information, the first row contains our column titles or header row:

Spreadsheet for example
example spreadsheet with header rows

We have the First Name, Last Name, Email, Phone, City, State and Interest. How do you find just the poker players? One option is to sort by Interest. However, ultimately, you need a list of only the celebrities you will invite and hand off the list to your friend who is helping you host the event. You want just the list of poker players.

How to Run a Filter

We have our list of celebrities and each column is titled (or our header row). Let's go through the process, step by step, and run a filter so that only the poker players remain:

To unlock this lesson you must be a Study.com Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support