Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Thermometer Chart in Excel
  • Number and Text Filters Examples in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Managing Conditional Formatting Rules in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel

References

  • How to use Excel LOOKUP Function
  • How to reference named range different sheet in Excel
  • Approximate match with multiple criteria in Excel
  • How to get relative row numbers in a range in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation only dates between
  • How To Create Drop-down List in Excel
  • Data validation must not exist in list
  • Excel Data validation require unique number
  • Excel Data validation specific characters only

How To Filter Data in Excel

by

Filter your Excel data if you only want to display records that meet certain criteria.

By filtering data in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data that you want to see.

Navigation: Data Tab → Sort & Filter Group → Filter

1. Click any single cell inside a data set.

2. On the Data tab, in the Sort & Filter group, click Filter.

Arrows in the column headers appear.

3. Click the arrow next to Country.

4. Click on Select All to clear all the check boxes, and click the check box next to USA.

5. Click OK.

Result. Excel only displays the sales in the USA.

6. Click the arrow next to Quarter.

7. Click on Select All to clear all the check boxes, and click the check box next to Qtr 4.

8. Click OK.

Result. Excel only displays the sales in the USA in Qtr 4.

9. To remove the filter, on the Data tab, in the Sort & Filter group, click Clear. To remove the filter and the arrows, click Filter.

Post navigation

Previous Post:

TRUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Pie Chart

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel AND Function
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • Get month name from date in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Display Date is workday in Excel
  • Two ways to sum time over 30 minutes in Excel
  • Get project midpoint in Excel

Grouping

  • Running count group by n size in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Group numbers at uneven intervals in Excel

General

  • Find, Select, Replace and Go To Special in Excel
  • Subtotal by color in Excel
  • Lock Cells in a Worksheet Excel
  • How to add sequential row numbers to a set of data in Excel
  • How to test a range for numbers in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning