I am sure you all know that the built-in list view has filters. You can choose items to display on page on the menu after you clicked on header of each column. With this filters, users can find the ones they want very easily.

What’s the default filters looks like

By default, you can filter the items by choosing the values you want one by one, just like the below screenshot shows. When the items are not so many, it works just fine. default item filters in SharePoint

What if there are hundreds of items?

First of all, you will get a menu like what the screenshot shows below.

A filter menu without the choices

It won’t show you anything until you clicked on the text “Show Filter Choices”. And after that, this will be what you got.

Filter menu with all the choices

The problem is that this filter menu is not that helpful, because

  1. There are too many choices in the dropdown list, a small move of scrollbar could cause a big change in the choices list.
  2. You can only select one option each time.
  3. If you want to switch to other choices, you have too go though these two steps again.

We can do better with List View Filter

List View Filter can help you with this situation by add more options for users to filter data. It supports the columns in these three types.

  1. Single line of text
  2. Date and Time
  3. Number, including Currency

After installed List View Filter on SharePoint server, the filter menu will be different from the built in one.

With Single line of text

You can get more methods to filter the items,

  1. Starts with. Search the column value starts with your input.
  2. Contains. Search the column value contains your input.
  3. Equals with. Search the column value equals with your input.

Advanced filter menu for Signle line of text

With Numeric columns

You can get more methods to filter the items,

  1. Equals with. Search the column value equals with your input.
  2. Not Equals with. Search the column value does not equal with your input.
  3. From * to *. Search the column value in the range of your inputs.

Advanced filter menu for Number and Currency

With Date and Time columns

You can get more methods to filter the items,

  1. Today. Search the column value equals with your today.
  2. This Week. Search the column value belongs to the current week.
  3. This Month. Search the column value belongs to the current month.
  4. Last Week. Search the column value belongs to the last week.
  5. Last Month. Search the column value belongs to the last month.
  6. From * to *. Search the column value in the range of your inputs, basically you can use this to filter dates based on a date range.

Advanced filter menu for Date and Time

You can find more details about this product here