Sort and filter data
Sort Data
You can quickly sort your data in a spreadsheet using one of the available options:
- Ascending is used to sort your data in ascending order - A to Z alphabetically or smallest to largest for numerical data.
- Descending is used to sort your data in descending order - Z to A alphabetically or largest to smallest for numerical data.
To sort your data,
- select a range of cells you wish to sort,
- click the Sort Lowest to Highest
icon situated at the top toolbar to sort your data in ascending order,
OR
click the Sort Highest to Lowesticon situated at the top toolbar to sort your data in descending order.
You can also sort your data using the Sort option from the right-click menu.
Filter Data
To display only the rows that meet certain criteria make us of the Filter option. To enable a filter,
- select a range of cells containing data to filter,
- click the Filter
icon situated at the top toolbar.
The drop-down arrow will appear in the first cell of each column of the selected cell range. It means that the filter is enabled.
To apply a filter, click the drop-down arrow . In the opened Filter window adjust the filter parameters proceeding in one of the following ways:
- Select the data to display
Uncheck the boxes near the data you need to hide. For your convenience all the data wintin the Filter window are sorted in ascending order. To facilitate the process make use of the search field. Enter your query, entirely or partially, in the field and press the Enter key.
If you need you can set the sorting order of the data to display clicking the
button to sort your data in ascending order, or using
button to sort them in descending order.
Note: the {Blanks} check box corresponds to the empty cells. It is available if the selected range of cells contains at least one empty cell.
- Apply the Custom Filter
Click the Custom Filter button in the upper right corner of the Filter window. In the opened Custom Filter window select one of the available criteria from the upper drop-down list and enter the necessary value in the field on the right.
To add one more criterion, click the And radiobutton if you need the data to satisfy both criteria or use the Or radiobutton if either or both criteria can be satisfied. Then select the second criterion from the lower drop-down list and enter the necessary value on the right.
The Filter button will appear in the first cell of the column. It means that the filter is applied.
Format as Table Template
To facilitate the work with your data Spreadsheet Editor allows you to apply a table template to a selected cell range automatically enabling the filter. To do that,
- select a range of cells you need to format,
- click the Format as Table Template
icon situated at the top toolbar.
- select the template you need in the gallery,
- in the opened pop-up window check the range of cells to be formatted as a table,
- check the Title if you wish the table headers to be included in the selected range of cells, otherwise the header row will be added at the top while the selected range of cells will be moved one row down,
- click the OK button to apply the selected template.
The template will be applied to the selected range of cells and you will be able to edit the table headers and apply the filter to work with your data.
Note: once you've created a new formatted table, a default name (Table1, Table2 etc.) will be automatically assigned to the table. You can change this name making it more meaningful and use it for further work.
Clear Filter
To clear the filter,
- select the range of cells containing the filtered data,
- click the Clear Filter
icon situated at the top toolbar.
The filter will remain enabled, but all the applied filter parameters will be removed, and the Filter buttons in the first cells of the columns will change into the drop-down arrows
.
Remove Filter
To remove the filter,
- select the range of cells containing the filtered data,
- click the Filter
icon situated at the top toolbar.
The filter will be disabled, and the drop-down arrows will disappear from the first cells of the columns.