Excel Data AnalysisLesson 30Free preview

Excel Filter

This lesson is part of Excel · All levels

Summary

The filter hides the unqualified lines so you focus on the data you're looking for. Once AutoFilter is activated, an arrow appears on the column header that you can use to select values, using Number Filters, or Text Filters. The filtered lines display blue row numbers as a marker that there is still hidden data.

Key points

Activate with Data > Filter or Ctrl+Shift+L
Column header arrows provide a checklist of values and a special filter
Number Filters and Text Filters add terms like Greater Than or Contains
The blue line number indicates another line is hidden.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.