How To Quickly Delete Blank Rows in a Worksheet

When working in Microsoft® Excel® you probably have had to deal with removing blank rows. This, you may agree, is annoying and time consuming, especially if you have a large worksheet with thousands of rows.

Well, instead of deleting the blank rows painstakingly one after the other, we’ll show you how you can delete them quickly and without much hassle.

Note: Download the blank rows workbook

Applies To: Microsoft® Excel® 2007, 2010 and 2013

  1. Select any cell within the worksheet.
  2. Press F5.
  3. Click on Special.

tip-1

 

 

 

 

 

 

  1. Select Blanks.

tip-2

 

 

 

 

 

 

 

  1.  Click OK.

tip-3

 

 

 

 

 

 

 

 

  1. Press CTRL and minus.
  2. Select Entire row.

tip-4

 

 

 

 

  1. Click OK.

tip-5

 

 

 

 

 

 

 

 

And that’s how you delete blank rows without much hassle!