From LibreOffice Help
Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in LibreOffice there are various possibilities for applying filters.
- One use for the AutoFilter function is to quickly restrict the display to records with identical entries in a data field.
- In the Standard Filter dialog, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect the conditions with either a logical AND or a logical OR operator.
- The Advanced filter allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.
|To remove a filter, so that you see all cells again, click inside the area where the filter was applied, then choose Data - Filter - Reset Filter.|
|This is the opposite to rows that you have hidden manually by the Format - Rows - Hide Rows command. Manually hidden rows are deleted when you delete a selection that contains them.|