How to Remove Blank Rows Microsoft Excel

‍

‍

Here's how to do it:

‍

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.