Removing Of Unwanted Rows In Excel

In this article you will learn how to easily remove of unwanted rows with just a few clicks. All easy and fun (without using macros or VBA). This trick will save a lot of your time during preparing data in tables.

Blank rows between the data can turn your day into nightmare. They certainly lose a lot of your precious time. If there are only a few rows then you can delete them manually. Worse when there are hundreds of blanks. Then this article brings help. Sometimes it may happen that you want to remove all empty row with just few clicks. How to do it in Excel?

You want to delete blank lines inside your table. An example table is in the image below.

Example Table

To get rid of blank rows in Excel:

1. Select whole table (with headers)

Table Highlighted

2. Press the F5 function key. In the window that appears select Special…

You can also go to Ribbon > Home section. 
Click Find & Select > Go to Special…

Go To Special

3. In the next window tick Blanks

Go To Special Blanks

4. Confirm by clicking OK and blank rows will be highlighted

Blanks Highlighted

5 Click on one of them, right-click and choose Delete…

The same in Ribbon > Home tab > Cells section. 
Click Delete > Delete Sheet Rows.

Delete Rows

6. In the next window choose Entire row.

Delete Entire Row

7. Confirm OK and be happy.

Blanks Removed

Blank lines are gone! Your table was cleared in a few seconds! This trick just saved a lot of time. Excel is powerful when you know such tricks.

Template

You can download the Template here – Download