How to Remove Blank Rows Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to delete blank rows from your Excel spreadsheet.

Quick summary

Removing blank rows in Microsoft Excel is done by using the Go To Special feature to select all empty cells, then deleting entire rows in one step. This method works across any data range and keeps your spreadsheet clean without manually hunting for gaps.

Steps

Highlight the range of cells where you want to remove blank rows.
Press Ctrl + G or F5 to open the Go To dialog box.
Click Special at the bottom-left corner of the dialog.
Select Blanks and click OK to highlight all empty cells in the range.
Press Ctrl + - to open the delete options dialog.
In the Delete dialog box, choose Entire Row and click OK to remove all blank rows.

📌 Why this matters

Blank rows in Excel can break formulas, disrupt sorting, and make data analysis unreliable. The Go To Special method lets users instantly select and delete all empty rows across a large dataset in seconds, without scrolling or manual selection. This approach is faster and more accurate than filtering or deleting rows one by one. Mastering this technique is essential for anyone who regularly cleans, organizes, or reports on data in Microsoft Excel.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel