Six Different Auto-filters You Can Do In Excel

A picture to show you that there are 6 and not 2 autofilter in Excel

#1 – Number Filter

The first one is the number filter.

Go to the quantity column under the drop-down, and you can choose the number.

And there’s this number filter, which allows you to filter according to

  • equal
  • does not equal
  • greater than,
  • less than,
  • above average, or
  • below average.

#2 – Text Filter

The 2nd filter is the text filter.

You can put filter using

  • equals
  • does not equal to,
  • begins with ,
  • ends with,
  • contain or
  • does not contain.

These are the first two filters that everybody knows.

#3 – Date Filter

50% of you probably do not know the 3rd filter – date filter. This date filter can filter before, after or in-between dates. It has multiple sets of before and after filter for day, week, month, quarters and years.

There is a separate filter to filter by Quarters 1-4 or by months.

#4 – Icon Filter

The fourth filter is the icon filter. You can filter your data by the icon on the left of the cells, presents as red, green, yellow arrows/circles.

#5 – Cell Colour Filter

Number five is the cell color filter. If your cells contain at least one colour, you can use this to filter the records for that specific colour. If you have more than one colours, all the colours will be listed and you can choose which coloured cells/rows you want to see.

#6 – Font Colour Filter

The sixth and final filter is for font colour. If you have more than one font colour (including the automatic black colour font) in a column, the autofilter function will list down the colours you can filter for the column. The font colour filter is also activated if you have formatted the negative numbers to show in Red

With these six filters in Excel, you will not have to spend so much time working on those data anymore. Check out the video below to see how they worked.

Popular Courses

Useful Links

Links I found useful and wanted to share.

Search the website