Office 365: Excel - Adding Filters to a Table

Overview

Filters in Microsoft Excel allow users to quickly sort and display just the data they want to see in a table or a dataset. Filters can hide rows that don't match the selected filter, without deleting or changing the original data. 

Considerations

• Your dataset should include column headers at the top of each column.
• Filters only apply to the selected range or table.
• Filtering hiders rows temporarily, but does not delete the hidden data.
• Steps may look slightly different depending on Excel version. (Windows or Mac)

Steps

1. Select any cell inside the table or dataset you want to filter. 
2. Navigate to the data tab in the Excel ribbon, towards the top of the page.
   
3. Click on the Filter button in the new ribbon that shows up. 
   
4. Click the arrows that appear on each column's header.
5. Select or deselect values to display only the rows that match what you want to see.
6. Click "Ok" or "Apply" to apply the filter. 

Tip: to remove a filter, click the Filter button on the Data tab again, or select "Clear Filter" from the dropdown menu after clicking the arrow in the header.

Apply a Filter

1. Click the arrow next to the header, to open up the dropdown menu.
   
2. Uncheck the "select all" box, and then select which option you want to see.
3. Click "apply", your table will update to match your selection.
4. Click the dropdown arrow again, and select "Clear Filter from 'header name'" to clear the filter.