Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How to use the AutoFilter

The AutoFilter is used to display only rows fitting a search criterion.

Suppose you have a list of French towns in column A, and the postal number of the department containing the town in column B.

Towns Departments
Bordeaux 33
Antony 92
Créteil 94
Paris 75
Briançon 05
Talence 33
Massy 91
Pessac 33

To use the AutoFilter:

  1. By default LibreOffice applies the AutoFilter to the whole of the range contiguous with the current cell. If this is not convenient, you must select the range to which you want the AutoFilter to apply.
  2. Go to Data ▸ Filter ▸ AutoFilter.
  3. Buttons giving you access to a drop-down list appear in the boxes of the first row of the selected area.
    • Click to display the list of unique values in the column with attached checkboxes, allowing you to choose the data to filter.
    • The dialog also shows two buttons Show only the current item and Hide only the current item. In our example, in the drop-down list in B1, select the value 33, click on Show only the current item and then on OK to display towns in the Gironde.
copie d'écran
Sélectionner 33, cliquer sur Afficher uniquement l'élément actif
Only rows with 33 in columne B are displayed.


To make all the records reappear: In the drop-down list in B1, check the All box, then OK. All the rows are displayed again, but the drop-down lists are still there.


To deactivate the AutoFilter: Go to Data ▸ Filter ▸ AutoFilter. The drop-down lists disappear and the spreadsheet returns to its normal apearance.


Managing several AutoFilters: In earlier versions of LibreOffice, to activate AutoFilter on more than one sheet, it was necessary to define a data range in advance (menu Data ▸ Define Range for each of the AutoFilters. The extension AutOooFiltre does this automatically. This limitation no longer exists except where you want several AutoFilters on the same sheet.