How to Remove Blank Rows Microsoft Excel

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

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