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

Go To Blanks | MyExcelOnline