Filter Spreadsheet Data Tutorial
Microsoft Excel
Objective: To filter spreadsheet data using Microsoft Excel

---

Introduction: Among the many functions that Microsoft Excel comes equipped with, the "Filter" function is one of the most useful. The "Filter" function allows users to filter through column and row data to locate specific spreadsheet information. Filtering allows the user to customize how the spreadsheet data is viewed on screen. The "Filter" function can be useful for educators who want to sort through large information files to identify student performance on tests and assignments.

---

Skill Practice: Filter data in an Excel Spreadsheet file

Step 1: Open . Open an existing Excel spreadsheet file, such as a Class Gradebook.

Step 2: Choose a variable that you want to filter, such as Total Points.

Step 3: Go to Data > Filter > AutoFilter. Filter boxes will appear at the top of each column.



Step 4: In the Total Points column, click on the filter arrow at the top of the column. A "filter menu" will appear.

Step 5: Choose the filter option you want to use, such as (Top 10...). The Top 10 AutoFilter window will appear. In the window, identify how many top (or bottom) "Total Point" scores you want to filter from the spreadsheet, such as 3. The entries for the three students with the most total points will appear on the spreadsheet.



Step 6: To Save Filter - Go to File > Save to save the filter adjustments to your spreadsheet.

Step 7: To "Undo Filter" - Click on the filter arrow , and choose (All). All student entries will reappear on the spreadsheet.