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.


DOWNLOAD WORKBOOK

 

STEP 1: Select the entire table containing your data

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

STEP 3: Select Blanks and click OK

STEP 4: Now we have the blank rows selected

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

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

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