Eliminate Blank Rows in Excel 2007

This is very common issue when we try to import data from somewhere else, we get many blank rows. If the spreadsheet contains small amount of data then we can do the removal manually, but if the data is too much, it’s not possible to do the removal manually. Microsoft Excel have very cool feature for this issue. By this article we will learn that simple trick to delete blank rows from your excel spreadsheets.

Follow the steps to solve this issue,

Open the desired worksheet
Select your data by command Ctrl+A (select all)
Press F5
This will opens “Go to” dialog box in Excel (as per screenshot)

 Now hit on that “special” button.
Then  select “Blanks” (as per screenshot)

Now, all the blank cells will be selected.

Just press CTRL and Minus sign (-)

Choose “shift cells up” or “entire row” as needed.

That is all. Now you have successfully removed blank rows.