How to delete blank rows in MS Excel?

2 posts / 0 new
Last post
#1 18 June, 2014 - 12:11
Ramakrishnan's picture

How to delete blank rows in MS Excel?

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?

18 June, 2014 - 13:15
Karthik's picture

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.

Log in to post comments