LibreOffice: Advent Tip #19

donations.ods - LibreOffice Calc_006 donations.ods - LibreOffice Calc_007

LibreOffice Calc allows to show quite easily the top 10 values in a spreadsheet column with the AutoFilter function, which is activated with the menu Data > Filter > AutoFilter (image on the left). Once active, the function shows a down arrow in the first cell of each column, which opens a drop down menu with different options (image on the right). The third option from the top, after Sort Ascending and Sort Descending, is Top 10 (values).

No Responses