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.
To do it first select whole table.
Go to Ribbon > Home section. Click Find & Select > Go to Special…
Dialog box appears. Click Blanks.
Excel highlighted every blank cell in your table.
Next go back to Ribbon > Home tab > Cells section. Click Delete > Delete Sheet Rows.
Now you can see, that Excel deleted blank rows.