Sort and filter data

Sort Data

You can quickly sort your data in a spreadsheet using one of the available options:

To sort your data,

  1. select a range of cells you wish to sort,
  2. click the Sort Lowest to Highest Sort Lowest to Highest icon icon situated at the top toolbar to sort your data in ascending order,
    OR
    click the Sort Highest to Lowest Sort Highest to Lowest icon icon 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,

  1. select a range of cells containing data to filter,
  2. click the Filter Filter icon icon situated at the top toolbar.

The drop-down arrow 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 Drop-Down Arrow. In the opened Filter window adjust the filter parameters proceeding in one of the following ways:

The Filter Filter button 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,

  1. select a range of cells you need to format,
  2. click the Format as Table Template Format as Table Template icon situated at the top toolbar.
  3. select the template you need in the gallery,
  4. in the opened pop-up window check the range of cells to be formatted as a table,
  5. 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,
  6. 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,

  1. select the range of cells containing the filtered data,
  2. click the Clear Filter Clear Filter icon icon situated at the top toolbar.

The filter will remain enabled, but all the applied filter parameters will be removed, and the Filter Filter button buttons in the first cells of the columns will change into the drop-down arrows Drop-Down Arrow.

Remove Filter

To remove the filter,

  1. select the range of cells containing the filtered data,
  2. click the Filter Filter icon icon situated at the top toolbar.

The filter will be disabled, and the drop-down arrows Drop-Down Arrow will disappear from the first cells of the columns.