BioloMICS logo
×
BioloMICS menu
Search
 
   
   
   
 

Filter

 
Movie BioloMICS: Sort and Filter, from 2.03 min.
 
 
  • 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.
     
    Filter
 
 
1

Sort A to Z

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

Sort Z to A

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

Clear filter from

3. Clear filter from
Clear the filter and to see the whole dataset again.
 
4

Text filters

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

Number filters

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

Filter by values

6. Filter by values
Filter by values present in the field of the selected column.
 
Note that multiple selection of filtered records includes not shown records in between.
 
(c) BioAware, 2024