Faq/Calc/033

    From The Document Foundation Wiki
    < Faq‎ | 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.

    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 ▸ 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.