How to delete empty rows in Excel

While working in Excel, empty rows quickly appear. Removing them is actually not complicated, but depending on the size of the table, it can mean a lot of work. That's why we'll show you how to delete empty rows in Excel within seconds.

In Excel 2013, you can find and delete empty rows in seconds.

Deleting empty rows in Excel is not complicated. The filter function makes it possible. To note here: The following explanation is based on Excel in Micosoft Office 2019.Microsoft Office 2019 Professional Plus: Buy license key cheap at MMOGA!

Delete empty Excel rows using the filter function

1. Mark the cells in the range from which you want to remove the empty rows.

2. Click on "DATA" at the top of the Excel menu and then on "Filter".

3. Click on the drop-down arrow, which is now visible at the first entries of the selected columns.

4. Uncheck "Select all" and check "Blank".

5. Now you will only see the empty lines. These appear in the enumeration on the left margin in blue font. Select all the blue numbers and remove the rows with "Delete rows".

6. After that, click on the dropdown arrow again and check "Select all" again. Now the other lines appear again, only with the difference that there are no more empty lines in between.

7. To finish, click "Filter" again at the top so that the button is deactivated.

No more empty rows exist in the selected area and you can continue working.

Downloads, Apps & Tips

To download: Microsoft Excel | Excel Mobile (Windows 10 app) | Excel OnlineOffice alternatives: free replacements for Microsoft OfficeThe 100 best free Microsoft programs to download Print