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
Click on the top left section of the sheet – between A and 1 to select the entire contents of the sheet.
From the menu, select Data -> Auto Filter.
In cell A1, click on the filter drop-down and select Empty.
After the above step, all the empty rows would be shown. Select all the empty rows till the end and click Delete Rows.
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.