Sample Data for Empty Rows

How to Delete Empty Rows in LibreOffice Calc Sheet

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.

Sample Data for Empty Rows
Sample Data for 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.

Select entire Sheet
Select entire 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.

Filter Empty
Filter Empty

 

Step 4

After above step, all the empty rows would be shown. Select all the empty rows till end and click Delete Rows.

SEE ALSO:  How to Type Unicode Characters in LibreOffice
Delete Empty Rows- Calc
Delete Empty Rows- Calc

Step 5

After deleting the rows, click on the filter at A1 and select all, press OK.

Filter - All
Filter – All

 

This would show you the final data with all the blank/empty rows removed.

After Removing empty rows
After Removing empty rows

 

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.


Join our Telegram channel and stay informed on the move.

Related


arindam

IT professional by profession and founder of libreofficehelp.com. Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

2 thoughts to “How to Delete Empty Rows in LibreOffice Calc Sheet”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.