Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Extract all partial matches in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Find closest match in Excel
  • How to use Excel COLUMN Function
  • How to get last row in numeric data in Excel

Data Analysis Examples

  • How To Sort One Column or Multiple Columns in Excel
  • Working With Tables in Excel
  • How to Create Area Chart in Excel
  • How to Create Gantt Chart in Excel
  • How to create a Histogram in Excel

Data Validation Examples

  • Excel Data validation number multiple 100
  • Data validation must not exist in list
  • Excel Data validation whole percentage only
  • Excel Data validation specific characters only
  • Excel Data validation no punctuation

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.

Worked Example:   Number and Text Filters Examples in Excel

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.

Worked Example:   How to Sort by Color in Excel

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.

Worked Example:   Add Outline to Data in Excel

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:

How To Sort One Column or Multiple Columns in Excel

Next Post:

Conditional Formatting Rules in Excel

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
  • Remove last characters from right in a cell in Excel
  • PHONETIC function: Description, Usage, Syntax, Examples and Explanation
  • How to pad text to match equal length in Excel
  • Clean and reformat telephone numbers using SUBSTITUTE function in Excel
  • How to create email address from name in Excel
  • Calculate days remaining in Excel
  • How to calculate next scheduled event in Excel
  • How to get number of days, weeks, months or years between two dates in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Convert date string to date time in Excel
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
  • DB function: Description, Usage, Syntax, Examples and Explanation
  • Bond valuation example in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles