\<bookmark_value\>filters; introduction\</bookmark_value\>\<bookmark_value\>advanced filters\</bookmark_value\>\<bookmark_value\>rows; deleting with filters\</bookmark_value\>

Applying Filters

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.

  1. One use for the \<emph\>AutoFilter\</emph\> function is to quickly restrict the display to records with identical entries in a data field.

  2. In the \<emph\>Filter\</emph\> dialog, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect up to three conditions with either a logical AND or a logical OR operator.

  3. The \<emph\>Advanced filter\</emph\> exceeds the three condition limitation and allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.

Tip Icon

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.


Note Icon

When you select filtered rows and then either apply formatting, or delete the selected rows, this action then applies only to the filtered rows. The hidden rows are not affected. This is the opposite to rows that you have hidden manually by the \<emph\>Format - Rows - Hide Rows\</emph\> command. Manually hidden rows are deleted when you delete a selection that contains them.


Note Icon

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.


Please support us!