Excel Pro Tip: Delete Blank rows in Excel workbook
This excel pro tip article will show you how to mark and delete all the blank rows from your excel workbook. Sometimes you get a large excel workbook and you see that it has intermittent blank rows. To make this kind of work book more streamlined, you can use below method.
Step (1) : Open the excel workbook.
Step(2) : On the Home tab, in the Editing group, Find & Select and click on “Go To…”.
Alternatively, you can also click Ctrl and G together ( Ctrl + G ) and it will open up one pop up window like below.
Step (3) : Click on Special and select Blanks as shown below.
Step(4) : Click on OK and it will highlight all the blank rows in Gray color.
Step(5) : On the Home tab, in the Cells group, click Delete.
Step(6) : Click “Delete Sheet Rows”.
Now you should have all the blank rows deleted from your worksheet.