Frequently asked questions - Calc
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.
To use the AutoFilter:
- 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.
- Go to ▸ .
- 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.
- 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 ▸ ▸ . 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 ▸ 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.