Deleting Blank rows, a simple technique

Deleting Blank rows, a simple technique

Suppose our data is like below, and we want to delete the blank rows, then no need to do this one by one, use the below technique.

Select the data where in between there are blank rows.

Press F5 button, the below window will appear, now click on Special

Now select the box of Blanks and press ok.

Now blanks are selected so to delete them press Ctrl – and shift the cells up, now data like below.