How to delete blank rows in MS Excel?

Submitted by Ramakrishnan on Jun 18, 2014 - 12:11

I have a huge number of data rows in Excel with lot of blank rows between them. 

How to remove the blank rows easily?

Is there any shortcut for this?


Jun 18, 2014 - 13:15

It's simply done using Go To

It's simply done using Go To Special command.


  1. Select the range of cells that contains data with blank rows.
  2. In the Home Tab Click on Find & Select (binocular icon), and chose the Go To Special menu option
  3. Choose 'Blanks' option then click Ok.
  4. Now, select Delete Sheet Rows option in the drop down menu by clicking the Delete icon under Home tab.

That's all.