Ubuntu – LibreOffice Calc – Delete empty rows

libreoffice

I'm using LibreOffice Calc and my data sheet contains a couple of empty rows. For example:

enter image description here

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.

Best Answer

Not in one go, but with a small workaround:

  1. Select the whole of your spreadsheet (e.g. by clicking in the empty square to the left of the "A" column header).
  2. Turn on Autofilter.
  3. From the drop down list at the top of a column, select "Empty" in each column until you end up with only empty rows.
  4. Select and delete these.
  5. Reset the filter.

Your non-empty lines will reappear.

Related Question