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

Go To Blanks

Helpful Resource:

MOTH-excel_expert470x63

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin