11

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.

15

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.