How do I filter reports in Excel?

Filtering a report allows you to easily find the information you are looking with ease.

How do I access the filter options?

The filter option within Excel can be found in the 'Data' tab and then selecting 'Filter'.

When using the Filter functionality, you need to select the range of data you want to filter. The easiest way to select a large amount of data is by selecting the column.

Once you have selected your data and hit the 'Filter' button, the columns will have a drop down option.

What filter options are available?

Selecting the dropdown on a column gives you multiple options on how to filter the data.

Sorting by 'A to Z' or 'Z to A' will filter the entire data range Alphabetically or Reverse Alphabetically via the selected column.

You are able to select certain data inputs to limit what will be shown. For large amounts of options, you can use the search bar to turn that content on or off. 

Using the '(Select All)' option, allows you to quickly select or de-select every content option by inputting/removing the check marks from all options.

Using the 'Text Filters' option allows you to search the column for data that equals or contains specific information.

Under this option you have several options that will be more or less appropriate dependent on the data you are looking for. 

Selecting one of these options brings up the ability to input your search criteria.

You can either use the drop down menu or type in your search criteria.

How do I clear my selected filter?

Once a filter option(s) is applied, you are able to clear all filters on a column with the 'Clear Filter From "_____"' option.