This tutorial will explain how to delete blank rows from LibreOffice Calc sheet.
Here are the steps.
Say, you have a Calc sheet with below data and some blank rows. Red arrows marked in below image identifying the empty rows.
Step 1
Click on the top left section of the sheet – between A and 1 to select the entire contents of the sheet.
Step 2
From the menu, select Data -> Auto Filter.
Step 3
In the cell A1, click on the filter drop down and select Empty.
Step 4
After above step, all the empty rows would be shown. Select all the empty rows till end and click Delete Rows.
Step 5
After deleting the rows, click on the filter at A1 and select all, press OK.
This would show you the final data with all the blank/empty rows removed.
This is how you can remove empty rows in LibreOffice Calc.
Drop a comment using comment box below if you are facing trouble with Calc or having any questions.
Looking for something else?
Read our complete tutorial index of Calc, Writer, Impress and Draw.
good idea. it helped me.
this does not work for me
Thanks a million 🙂
very simple & quick solution…..Thanks a lot……
Awesome. Thank you
This does not work.
Thank you.
For it to work properly, we should select for deletion only he rows which show up in blue in the row numbers on the left. In step 4, these row numbers are shown with black numbers in the image. In LibreOffice Calc, these now show as blue, to indicate that these are filtered rows. (ver 7.3 currently) [see attached image].
If we select all rows, or select the header row, all rows will be deleted, not just the empty ones.