Filter

To apply a filter to the data in the BioSheet/grid, under Data, in the Sort & Filter group, select Filter.
Sort options are then added to the columns in the grid.

Sort A to Z

Sort the data from A to Z. Note that is applies to the whole dataset.

Sort the data from Z to A. Note that is applies to the whole dataset.

Clear the filter and to see the whole dataset again.

When the selected column contains text data, then the following filter options will be available.

When the selected column contains numeric data, then the following filter options will be available.

Filter by values present in the field of the selected column.

Note that multiple selection of filtered records includes not shown records in between.