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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Row Differences If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find & Select > Go To Special > Row Differences.Once the cells have been identified, you ca...
Rank Smallest to Largest With Excel Pivot Tables  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the RANK SMALLEST TO LARGEST calculation.This option will immediately calculate the rankings (1 being the smallest value) for your values, allowin...
Text To Columns: Dates Whenever you download data from an external ERP system like Oracle, SAP, etc, you can have data that is not formatted the way you and Excel likes.Sometimes "Date" values are downloaded as "Text", so you cannot sort in the periodic date format.No worries!  Text to Columns ...
Extra Excel Table Styles The Excel Table Styles give a user a choice of different styles ranging from Light, Medium and Dark.There are over 50 choices depending on your favorite style or company standard but you are not only limited to those.You have extra Table styles in the Page Layout tab in y...