The Go To Special tool within Excel is a must for any serious Excel user as it has an array of useful spreadsheet formatting and clean up tools.

One that I use all the time is the Go To Special > Blanks.  This allows you to delete multiple blank rows/column within seconds.  I show you how below.

Go To Blanks | MyExcelOnline

DOWNLOAD WORKBOOK

 

STEP 1: Select the entire table containing your data

Go To Blanks | MyExcelOnline

STEP 2: Press CTRL + G to open the Go To Dialog. Click Special

Go To Blanks | MyExcelOnline

STEP 3: Select Blanks and click OK
Go To Blanks | MyExcelOnline

STEP 4: Now we have the blank rows selected

Go To Blanks | MyExcelOnline

Right click on a blank row, and go to Delete > Table Rows

Go To Blanks | MyExcelOnline

Now your blank rows are now deleted in a blink of an eye!

Go To Blanks | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn