How to delete 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.

Excel with Microsoft 365 and IONOS!

Use Excel to create spreadsheets and organize your data - included in all Microsoft 365 package!

Office Online
OneDrive with 1TB
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 can subsequently 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.

Excel with Microsoft 365 and IONOS!

Use Excel to create spreadsheets and organize your data - included in all Microsoft 365 package!

Office Online
OneDrive with 1TB
24/7 support

We’re all in this together. IONOS is
#HereForYou
For your business. When times are tough. When it matters most.
Keep your business going or start one with your own online store.
3 months free
Online Store
Get started in the world of eCommerce free for 3 months.