LibreOffice Calc - Delete empty rows

Question

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.

score 43 · Accepted Answer · edited May 21 '22 at 21:35

43

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.

edited May 21 '22 at 21:35

lewis4u

4,866

answered Aug 06 '17 at 19:47

Jos

29,224

5

Small addition for non-familiar with Autofilter (as me) https://help.libreoffice.org/Calc/Applying_AutoFilter Thank you, it works great. Standard filters with custom expressions helped me a lot. – reconsio Jun 11 '18 at 20:03
I used this the other way : in the autofilters list, i unchecked only 'empty' and copied the remaining cells in another – Benj Nov 06 '19 at 10:18
2

"Turn on Autofilter" is in menu Data > Autofilter, and "Reset the filter" is Data > More Filters > Reset Filter – M.M Aug 03 '20 at 09:48

score 5 · Answer 2 · answered May 13 '20 at 07:12

5

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.

answered May 13 '20 at 07:12

stragu

1,958

...though alas in a different order. – user643722 May 10 '23 at 14:56

score 1 · Answer 3 · answered Mar 15 '22 at 23:22

1

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

answered Mar 15 '22 at 23:22

Rafael

655
2
6
12

LibreOffice Calc - Delete empty rows

3 Answers3