Press "Enter" to skip to content

How To Delete Blank Rows In Microsoft Excel

Luigi Iacobellis 0

Blank rows are one of the most common (and annoying!) challenges when trying to analyze and manipulate large data sets in Microsoft Excel. Fortunately, there is an incredibly quick and easy way to delete blank rows in Microsoft Excel. The article below will show you how you can delete blank rows in Microsoft Excel in five simple steps. Be sure to check out the YouTube Tutorial below if you want to see how to use this shortcut to quickly delete blank rows.

 

Shortcut To Delete Blank Rows In Microsoft Excel

To easily delete blank rows in Microsoft Excel follow these steps.

Step 1: Open your spreadsheet and press “CTRL + G” on your keyboard. This is the keyboard shortcut that will open the Go-To menu. The Go-To menu allows you to quickly navigate to a specific cell or reference in your worksheet.

How to delete blank rows in Microsoft Excel

Step 2: Click on the “Special” button in the Go-To menu.

How to delete blank rows in Microsoft Excel

Step 3: Check the “Blanks” option and click “Ok”. This will automatically select all of the blank rows in your spreadsheet.

How to delete blank rows in Microsoft Excel

Step 4: Click on the “Home” tab and then click on the “Delete” dropdown arrow in the Cells group.

How to delete blank rows in Microsoft Excel

Step 5: Click on “Delete Sheet Rows”. This will delete the rows that are automatically selected in Step 3.

How to delete blank rows in Microsoft Excel

And that’s it! This shortcut is a useful trick to save you time when trying to remove blank rows from a Microsoft Excel spreadsheet. Be sure to subscribe to my mailing list to receive Microsoft Excel tutorials delivered straight to your inbox.

.

Leave a Reply

Your email address will not be published. Required fields are marked *