Sorting and filtering data

Sort data

Sort your data to organize it alphabetically or numerically:

1. Select the range of cells you need to sort.
2. Tap the icon in the top toolbar to open the object insertion panel.
3. Switch to the Other tab.
4. Tap the Sort and Filter option.

   

5. Choose how to sort:

   — sorts in ascending order — A to Z for text, smallest to largest for numbers.

   — sorts in descending order — Z to A for text, largest to smallest for numbers.

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 the range of cells containing the data you need to filter.
2. Tap the icon in the top toolbar.
3. Switch to the Other tab.
4. Tap the Sort and Filter option.
5. Turn the Filter switcher on.

   A drop-down arrow will appear in the first cell of each column in the selected range. It means that the filter is enabled.

To apply a filter:

1. Tap the drop-down arrow to open the Sort and Filter panel.

   

2. Deselect the data you need to hide. You can also use Select all to toggle everything at once. Swipe up or down to see all entries. Tap anywhere outside of the Sort and Filter panel to close it.

   The Filter button will replace the drop-down arrow in that column, meaning the filter is applied.

Sort filtered data

Once a filter is enabled or applied, you can set the sorting order of the data. Tap the drop-down arrow or the Filter button and pick:

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

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

Clear filter

To reset or clear the filter:

1. Tap the Filter button in the first cell of the filtered column.
2. Select Clear on the Sort and Filter panel.

The filter will remain enabled, but all the applied filter parameters will be removed. The Filter buttons will change back to drop-down arrows .

Remove filter

To remove the filter:

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

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