Filter, sort data

Select a filtering and sorting range

1.Select a range of cells with data. The range cannot consist of a single row.

2.On the Home tab, in the Data group, click Filter or, in the context menu, select Filter.

The active range will be highlighted with a green frame. The upper line of the range marked with the ▾ icon does not participate in the filtering and sorting processes.

Automatic range detection

The application can automatically detect a range if there is data in neighboring cells.

1.Select an empty cell that borders the data range.

2.On the Home tab, in the Data group, click Filter.

Using filtering, you can hide or display cells in a column. You can use different filters for each column.

Basic filtering by value

1.Click the ▾ button in the top cell of the column.

2.In the window that opens, check or uncheck the check boxes for the values you want to display or hide.

•Use the Select all option to quickly select or clear all check boxes.

•Use the Find bar to quickly find the values you want.

3.Click OK to apply the filter or Cancel to cancel the filtering.

When you copy a range of cells, data hidden by filters is not copied.

Filter by fill color

1.Click the ▾ button in the top cell of the column.

2.Select the By color method (available if the column has filled cells).

3.In the palette, select a fill color.

4.Click OK.

Filter by condition (for dates and numbers)

1.Click the ▾ button in the top cell of the column.

2.Select the By condition method.

3.From the drop-down list, select the desired condition.

4.Enter the required value in the required fields. You can use the select button on the calendar to enter the date. You can clear the field with the × button.

5.Click OK.

Only one filter type can be set for a column at a time.

Update filter

To update the filter (if the data in the range has changed):

1.On the Data tab, click the arrow under the Filter button.

2.From the menu, select Reapply filter.

Clear filter

To remove all filters from the table:

1.On the Data tab, click the arrow under the Filter button.

2.From the menu, select Clear filter.

To clear the filter for only one column:

1.Click its ▾ button.

2.In the window, click Clear filter.

Finalize a range

To finalize the filtering and sorting operation (the green box disappears), on the Data tab, click Filter. Only the sorting results will be saved in the table.

Sort by column

1.Click the ▾ button in the top cell of the column.

2.In the window that opens, select:

•In ascending order — to sort by ascending values.

•In descending order — to sort by descending values.

Complex sorting by multiple columns

1.Select the range of cells to be sorted.

2.On the Data tab, click the arrow under the Sorting button and select Sorting order.

3.In the window that opens, select the columns and the sort order for each of them. By default, sorting is performed on the first column. To add a column, click Insert column.

4.Click Sort to apply or Cancel to exit.

In tables created in third-party editors and loaded into a web application, you must first select the object with the mouse to work with filters.