Site icon Professor Excel

Filters: How to Use Filters in Excel

filters, filter, autofilter, excel, How to Use Filters in ExcelYou received a large Excel table, possibly as output of a database system. The first approach when working with data in Excel is often the filter function, previously called “Autofilter”. In this article we explore the functions of filters in Excel and how to use them.

 

What are filters good for?

 

How to set up filters in Excel?

Setting up filters in Excel is easy (the numbers are corresponding to the picture above):

  1. Select all your data you want to be filtered.
  2. Click on “Filter” on the Data ribbon or alternatively press Ctrl + Shift + l

Now, small arrow boxes are added on the header row (3).

Please note that only the first 1,000 values are shown (in alphabetical order). Please be careful sorting your data as formulas or cell references might be damaged.

Exit mobile version