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.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline