How to remove empty rows?

In this lesson you will learn how to remove empty rows from your table in Excel. This trick will save a lot of your time during preparing data in tables.

Sometimes it may happen that you want to remove all empty row with just few clicks. How to do it in Excel?

This is sample table. As you see some data is missing. You want to remove empty rows.

Remove Rows Table

To do it first select whole table.

Remove Rows Data

Go to Ribbon > Home section. Click Find & Select > Go to Special…

Remove Rows Special

Dialog box appears. Click Blanks.

Remove Rows Blanks

Excel highlighted every blank cell in your table.

Remove Rows Empty Cells

Next go back to Ribbon > Home tab > Cells section. Click Delete > Delete Sheet Rows.

Remove Rows Delete

Now you can see, that Excel deleted blank rows.

Excel Remove Rows