This tutorial will explain how to delete blank rows from the LibreOffice Calc sheet.
Say you have a Calc sheet with the below data and some blank rows. Red arrows are marked in the image below to identify the empty rows.
Table of Contents
Delete empty rows in LibreOffice Calc
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 cell A1, click on the filter drop-down and select Empty.
Step 4
After the above step, all the empty rows would be shown. Select all the empty rows till the 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 the comment box below if you are facing trouble with Calc or have any questions.
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.