# How to Remove Blank Rows Microsoft Excel

> To remove blank rows in Excel, highlight the cell range, press Ctrl + G or F5 to open the Go To dialog box, and click Special. Next, select Blanks and click OK. Finally, press Ctrl + -, choose Entire Row in the Delete dialog box, and click OK.

Canonical: https://livedemo.ai/tutorials/how-to-remove-blank-rows-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4be2ab56e05a00ff7512/preview?step=1

## 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 on Special at the bottom-left corner.
4. Select Blanks and click OK .
5. Excel will highlight all blank cells in the selected range. Press Ctrl + - to open the delete options.
6. In the Delete dialog box, choose Entire Row and click OK .