How to remove blank rows in Excel

When you start to create an Excel spreadsheet, you do not always have an exact structure in mind: After some reworking, you may have some blank rows in the spreadsheet and want to get rid of them as quickly and easily as possible. Fortunately, it’s not difficult to remove all blank rows at once – if you know how. We show you two methods.

Register a domain name

Build your brand on a great domain, including SSL and a personal consultant!

Private registration
24/7 support

Variant 1: Use the Search Feature in Excel to Remove Blank Rows

Deleting a single row is not difficult in principle: Mark the row with the right mouse button and select “Delete”. In this way, you can delete rows one after the other – regardless of whether they are empty or filled. However, there are always situations where you want to delete not just a single line, but all empty rows.

To delete all empty rows in Excel, first select a column in the table and then use the function “Go to…” under the option “Find & Select”. In the opening window, you can reach a selection menu via the button “Special…”. There you choose “Blanks”. Now Excel should have automatically selected all blank cells in the selected column.

The marked rows cansubsequently be deleted together. In the “Home” tab, you will find the option “Delete cells…” under the option “Delete”. If you now click “Entire row”, Excel removes the entire row where program previously found an empty cell. It is important that you do not click away or lift the marked area in the meantime.

Variant 2: Use Filters to Hide or Delete Blank Rows

Not only can you use the search function to delete blank rows, but you can also use a filter instead. To do this, first mark the area from which you want to remove the blank rows. In the “Data” tab, you will find the “Filter” function. Clicking on the button creates a filter for each of the selected columns. Excel generates a drop-down menu in the title bar. There you can now select which content should be displayed. One selection possibility is “Blanks”. If you remove the check for this point, Excel hides all blank rows.

But you can also use the filter menu to show all empty rows. The blue text on the left edge indicates which of the rows belong to the selected filtered area and where the actual table ends. Now highlight all empty rows and remove these rows. Then open the filter drop-down menu again: You should no longer find a choice for blanks and you should be able to show all the populated rows again.

HiDrive Cloud Storage with IONOS!

Based in Europe, HiDrive secures your data in the cloud so you can easily access it from any device!

Highly secure
Shared access
Available anywhere