I have a document with 3,000 rows. Interspaced throughout the document there are a few dozen empty rows. How do I find and delete all blanc rows at once instead of one at a time? Thank you.
If you are willing to use an extension, one possibility is Remove Blank Cells developed by Rafael Lima from the Brazilian LibreOffice community.
You can download it from: (https://extensions.libreoffice.org/en/extensions/show/5747).
Usually I just sort the table, delete blank rows, then sort to the previous order.
If it is no ordered setup I could use the line numbers to create one, or use a standard filter and show only blank rows.
I like how clean this appears to be : )
There is another fast way to delete any rows.
We add a column in which we mark 1 rows to be deleted and 0 the rest. Sort the range by the new column and remove the contiguous range with value 1. When sorting, Calc preserves the original order of the rows inside the sort key.