Short tutorial to delete blank rows in excel

Introduction

Removing blank rows from an excel sheet should be easy. Instead of digging into the documentation or watching a long video tutorial, just take a look at the following screenshots. Note that this tutorial was prepared using on Mac. For Windows, the procedure should be fairly similar…

• Select your data range

• From the Edit menu, Go to Find then click Go To

• Click Special

• Select Blanks

• Go to the Edit window then click Delete

• Select how you want to delete the rows. You can delete the entire row or just the selected cells (Shift cells up)

That is all you need. I hope this tutorial was useful and to the point.