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

Lookup and Reference Examples

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Two-column Lookup in Excel
  • How to get address of last cell in range in Excel
  • How to use Excel INDIRECT Function
  • How to use Excel MMULT Function

Data Analysis Examples

  • How to count table rows in Excel
  • Error Bars in Excel
  • How to sum a total in multiple Excel tables
  • Conditional Formatting Color Scales Examples in Excel
  • Create Scatter Chart in Excel

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation don’t exceed total
  • Excel Data validation must begin with
  • Excel Data validation require unique number
  • Excel Data validation unique values 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.

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:   Randomize/ Shuffle List 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:   Filter Data Based on Date 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
  • CODE function: Description, Usage, Syntax, Examples and Explanation
  • How to check cell contains which things in Excel
  • How to find and replace multiple values at same time in Excel
  • How to count total words in a range in Excel
  • Remove text by matching in a cell in Excel
  • Two ways to sum time over 30 minutes in Excel
  • How to calculate nth day of week in month in Excel
  • Calculate number of hours between two times in Excel
  • How to calculate nth day of year in Excel
  • Get month from date in Excel
  • How to calculate simple interest in Excel
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles