This tutorial will help you work with Filters feature in LibreOffice Calc (an alternative to Microsoft Excel) to create and use them. This feature, also known as AutoFilter, can help filtering and sorting out data in certain ways. You can download the document example below and go practice immediately. Now let’s exercise!
Subscribe to UbuntuBuzz Telegram Channel to get article updates.
Dataset
Type this dataset and save it as calc-data-filters.ods and give the worksheet name FILTERS. Alternatively, download the document file below. However, this dataset is almost similar to the one we used previously in Calc VII VLOOKUP.
Creating Filters
1. Select cells from A1 to H1 (e.g. from “ID” to “SOCIAL”).
2. Go to menu Data -> AutoFilter.
3. Filters created in the top of all columns.
Using Filters
As an example, let’s show only female students out of the dataset:
1. Click arrow button in the GENDER.
2. Check FEMALE option.
3. Uncheck MALE option.
4. Data filtered out to show only female students. Notice a dot sign appeared in the button when filter is active.
5. To show male students instead, do the above in reverse.
6. To disable a filter, click cross [X] button and make sure all options checked.
Showing only female students:
Showing only male students:
Using Filters for Numerical Data
Another example is to filter out students’ ID numbers and scores in several ways.
Sort out students reversely:
From the original data ABI on top and CLAUDIA on bottom.
1. Click ID arrow button.
2. Filter will show under ID.
3. Select Sort Descending.
4. Data will be sorted out reversely with CLAUDIA on first place and ABI on last place.
Show top ten scores:
From the original data with no active filters:
1. Click ENGLISH arrow button.
2. Filter will show under ENGLISH.
3. Select Top 10 option.
4. Select Sort Descending option (optional).
4. Data will be filtered out with ten best scores in English with CINTA on first place (100) and AHMAD on last place (76).
Using Filters in Combination
For example, we want to filter out MALE students from CITY A only.
1. Select filter MALE under GENDER.
2. Select filter CITY A under ADDRESS.
3. Data will be filtered out to show only DONI, BAYU, and ABI.
4. To revert back to normal, disable the two filters.
To this point, you’ve learned about basic use of Filters with examples.
Next time, you can continue your study to exercise Pivot Table or choose your lesson from our Calc Collection. See you next
time!
****
This article is licensed under CC BY-SA 3.0.