How to filter in Excel ?
|
Excel
|
5 months ago
|
Excel
7 Steps
Learn how to quickly sort and filter your data in Excel to find specific information. This document will teach you how to use the filter function to display only the relevant data you need. You'll learn how to filter by text, numbers, and dates. Discover how to create custom filters to refine your search criteria. With these skills, you can easily analyze and extract valuable insights from your data.
How to filter in Excel ?
|
Excel
|
Excel
7 Steps
1
Start Excel and open the workbook that contains the data you want to filter.
Make sure the data is organized in a table format, with headers at the top of each column.
2
Click and drag to select the range of "Cells" you want to "Filter". This usually includes the header row and all the data below it.
If your data is in a structured table, you can just click any cell within that table.
3
Click on the "Data" tab on the menubar.
4
Click on the "Filter" button (it looks like a funnel).
This action will add dropdown arrows to each of the header cells in your selected range, indicating that filtering is available.
5
Click the "Dropdown" arrow in the header of the column you want to filter.
This opens a menu with options to sort the data and filter specific values.
6
In the dropdown menu, you can choose "Filter Criteria"
This allows you to refine your data view based on the criteria you set.
7
After selecting your filter criteria, click the "Apply" button.
Excel will now hide any rows that don’t meet your specified criteria, showing only the relevant data.
