Data Fidelity

LibreOffice Calc: Create and Use Filters

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.

More In Technology News

Contact Data Fidelity

Send us a quick message, and we will endeavour to contact you as soon as possible. 

Alternatively, feel free to use our complimentary Quote Tool service to find our how much a new website will cost you today.

Contact Us

Take control of the internet

Download a FREE copy of our E-book, covering:

  • Origins of the internet, CERN & The GNU Philosophy
  • Misconceptions around the internet & its best practices
  • Database Architecture & Design
  • Exiting Big Tech
Book Subscription
Skip to content