LibreOffice Calc – Delete empty rows
I’m using LibreOffice Calc and my data sheet contains a couple of empty rows. For example:
I’d like to know how I can delete all empty rows from the selection. As a workaround I’ve tried to copy the selection, remove it, then “paste special”, tick “Skip empty cells”, however this did paste all the empty cells as well.
If there was a way to select all empty rows from a given selection then I could simply delete them. However I didn’t find a way for that either.
Not in one go, but with a small workaround:
- Select the whole of your spreadsheet (e.g. by clicking in the empty square to the left of the "A" column header).
- Turn on Autofilter.
- From the drop down list at the top of a column, select "Empty" in each column until you end up with only empty rows.
- Select and delete these.
- Reset the filter.
Your non-empty lines will reappear.
Another workaround would be to sort the data by a column that you know will contain a value for every single row that contains data.
- Select column range
- Data > Sort…
All relevant rows should end up at the top.
I know this question is quite old right now, but recently an extension has been released that makes it quite easy to remove empty rows and columns in a variety of ways.
It is on Github: https://github.com/rafaelhlima/remove_blank_cells