Filter by values

To filter the range by value, follow the steps below:

1.Define the sort and filter range.

2.Click the Sort and filter button in the upper cell of the column where you want to filter the data.

3.In the window that opens, make sure that the Filter by value option is selected and clear the Select all checkbox.

4.If necessary, you can adjust the width and/or height of the window:

•To increase or decrease the window width, move its right border to the left or right.

•To increase or decrease the window height, move its bottom border up or down.

•To adjust the window width and height simultaneously, move its bottom right corner in the desired direction.

5.Select the checkboxes next to the values you want to display in the column.

6.If the selected filter range has cells in the Date or Date and time format, their values are grouped in the list by year and month. To expand a grouped list row, click the button.

7.If the list contains a large number of values, use the search bar:

•Enter the value you want to find (in full or partially). For example, to find the number 123, you can enter the numbers 12, 23 or 123 in the search bar.

•You can search for dates by entering all or part of a numeric value (for year, month, and number), the name of a month, or the entire date in the format “MM.DD.YYYY” or “MM.DD.YY”. In this case, if you enter “01” in the search, the year 2001, January, 1st day will be displayed, and if you enter “1”, January will not be included in the search results (the month corresponds to “01”, but not to “1”).

•In the search results, select the checkboxes next to the values you want to display in the column.

•If necessary, repeat the steps to find and select other values.

8.Click Apply.

If you need to add additional values to the filtered list, click the Sort and filter button in the upper cell of the column again and, without clearing the filter, use the search bar:

1.Enter the value you want to find (in full or partially).

2.In the search results, select the checkboxes next to the values you want to display in the column.

3.Clear the search bar by deleting the value or click the button on the right side of the bar.

4.If necessary, repeat the steps to find and select other values.

5.Click Apply.

The appearance of the sort and filter button may differ from the one shown here because it depends on whether sorting has been previously applied, the sort order (ascending or descending), and whether a filter has been previously applied:

–: No sorting or filtering applied.

–: Filter applied, no sorting applied.

–: Sorted in ascending order with no filter applied.

–: Sorted in descending order with no filter applied.

–: Sorted in ascending order with filter applied.

–: Sorted in descending order with filter applied.

To clear the filter applied to a column by value without resetting the sorting, follow this steps:

1.Click  Sort and filter.

2.In the window that opens, select the Select all checkbox.

3.Click Apply.

To clear the filter applied to the column by value along with the sorting, do the following:

1.Click  Sort and filter.

2.In the window that appears, click Clear.