Sort and filter data

Sort Data

To sort your data:

1. Select a range of cells you wish to sort.
2. Tap the icon at the top toolbar, to open the new object insertion panel.
3. Switch to the tab.
4. Select the Sort and Filter option.
5. Tap one of the icons:

   - to sort your data in ascending order - A to Z alphabetically or smallest to largest for numerical data.

   - to sort your data in descending order - Z to A alphabetically or largest to smallest for numerical data.

Filter Data

To display only the rows that meet certain criteria and hide other ones, make use of the Filter option.

To enable a filter:

1. Select a range of cells containing data to filter.
2. Tap the icon at the top toolbar, to open the new object insertion panel.
3. Switch to the tab.
4. Select the Sort and Filter option.
5. Turn the Filter switcher on.

   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:

1. Tap the drop-down arrow . The Sort and Filter panel will open:

   

2. Deselect the data you need to hide.

   Swipe top or bottom to view all the entries and touch those you do not want to display. When ready, tap anywhere outside of the Sort and Filter panel to close it.

   The Filter button will appear in the first cell of the column. It means that the filter is applied.

Sort filtered data

You can set the sorting order of the data you have enabled or applied filter for. Tap the drop-down arrow or the Filter button and select one of the options on the Sort and Filter panel:

- to sort your data in ascending order, displaying the lowest value on the top of the column.

- to sort your data in descending order, displaying the highest value on the top of the column.

Clear Filter

To clear the filter:

1. Tap the Filter button in the first cell of the column that contains the filtered data.
2. Select the Clear option on the Sort and Filter panel that opens.

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:

1. Tap the Filter button in the first cell of the column that contains the filtered data.
2. Select the Remove filter option on the Sort and Filter panel that opens.

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