LibreOffice Calc 5.2 give you that ability to filter the content of cells in a column. The AutoFilter feature thus enable you to add a combo box to a column header so that you can with it specify filter criteria of cells that you want to be displayed.
To use this feature, you will first
Clicking on it will bring out some pre-define filter criteria you can choose from, like the Top 10 filter criteria will display ten cells with the highest numeric data value, while the rest will be hidden.
To display all the cells back, just click on the OK button in the menu that will appear when you click on the AutoFilter combo box.
To specify your own filter criteria, click on the Standard Filter... option in the AutoFilter menu.
Also Read:
To use this feature, you will first
- Select the column header you want the AutoFilter to be used on.
- Click on the Data menu in the menu bar and then click on AutoFilter in the menu that will appear.
Clicking on it will bring out some pre-define filter criteria you can choose from, like the Top 10 filter criteria will display ten cells with the highest numeric data value, while the rest will be hidden.
To display all the cells back, just click on the OK button in the menu that will appear when you click on the AutoFilter combo box.
To specify your own filter criteria, click on the Standard Filter... option in the AutoFilter menu.
Also Read:
- Three (3) Different Ways To Insert New Worksheet In A Workbook | LibreOffice Calc 5.2
- Formatting The Fill Of A Chart Component | LibreOffice Calc Version 5.2
- Inserting New Cell(s) In LibreOffice Calc V5.2.3
- How To Use The "Custom sort order" Of The Sort Option | LibreOffice Calc 5.2
- Hide And Unhide Row or Columns | LibreOffice Calc Spreadsheet V5.2
Team Pinfoltd
0 comments: