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.
Best Answer
Not in one go, but with a small workaround:
Your non-empty lines will reappear.