Excel Tip for Removing blank cells

Excel Tip for Removing blank cells

    Select the 'Cell' where we need to remove the blank cell.

    Press the F5, shortcut to Open Go To Popup.

        

   Click on Special -> Select  Blanks Radio button -> OK

   Ctrl- (minus) Delete Pop up , select Entire Row.