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…”.

Excel ProTip : "Go To..."
Excel “Go To…”

Alternatively, you can also click Ctrl and G together ( Ctrl + G ) and it will open up one pop up window like below.

Excel Pro Tip: Excel Go To window
Excel “Go To…” window

Step (3) : Click on Special and select Blanks as shown below.

Excel Pro Tip: Go To Special window
Excel Pro Tip: Go To Special window

Step(4) : Click on OK and it will highlight all the blank rows in Gray color.

Excel pro Tip : Selected Blank Rows
Excel pro Tip : Selected Blank Rows

Step(5) : On the Home tab, in the Cells group, click Delete.

Excel Pro Tip : Delete
Excel Pro Tip : Delete

Step(6) : Click “Delete Sheet Rows”.

Now you should have all the blank rows deleted from your worksheet.

Excel Pro Tip: Result
Excel Pro Tip: Result

Leave a Reply

Your email address will not be published. Required fields are marked *