Score:0

Delete hidden rows from LibreOffice Calc

ar flag

I want to delete all rows except selected rows from a sheet. Rows are selected after applying the filter. Thanks in advance

Score:0
in flag

in your Calc spreadsheet, select the rows you wish to delete by left clicking with your mouse on the row number whilst holding the Ctrl key to obtain multiple selections.

Right click on one of the selected rows and from the drop down menu select "Delete Rows".

This will delete all the selected rows.

Current version tested v7.3.03

Score:0
lu flag

There isn't a way to invert selections directly. Instead, you could negate the filter, for example by adding NOT(). Or, copy the selected rows to a new sheet and delete the original.

Related: https://ask.libreoffice.org/t/reverse-selection-using-calc/24538

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.