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

HLOOKUP Function in Excel

HLOOKUP Function Glossary What is HLOOKUP? HLOOKUP Example Exact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook

Read More »

DATEDIF Function

The DATEDIF Function in Excel is used to calculate the number of days, months, or years between two dates. A

Read More »
Scroll to Top