How to Remove Blank Rows Microsoft Excel

Guide

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.