How to apply Multiple Filters in Excel

We are going to cover how to use Multiple filters in Excel. A Filter is cumulative, this implies that you can apply multiple filters to help find your result.

  • Left click on the arrow for the column you wish to filter.
Multiple filters in excel
  • The filter option will appear
  • Check or uncheck any box depending on the data you wish to filter, then click ok.
Multiple filters in excel
  • Filtering will be applied. In the example below, the spreadsheet is now filtered to show only laptops and tablets that were cop-out in August
Multiple filters in excel

Leave a Reply

SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common

Read More »

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »
Scroll to Top