Blank rows or Blank cells is a problem we all inherit one time or another. This is very common when you try to import data from somewhere else (like a text file or a CSV file). Today we will learn a very simple trick to delete blank rows from excel spreadsheets.
Select your data
This opens “Go to” dialog in Excel. Now hit on that “select” button.
From “select special” screen, select “Blanks” (shown aside)
Now, all the blank cells will be selected.
Just press CTRL and Minus sign (-)
Select “shift cells up” or “entire row” as needed.
That is all. If your file is large it could take long time to finish it. Be little bit patient.