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

Share on Google+

Google+

Related Posts

Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data. You can then go over to another column within your data and select another item, apply the same steps above and further filter ...
Excel Number Formats – Thousands & Mill... Large numbers in Excel can be formatted so they can be shown in "Thousands" or "Millions". By using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions. You can even add som...
Show The Percent of Parent Column Total With Excel...   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 PERCENT OF PARENT COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers suc...
Filter Unique Records The Advanced Filter allows you to filter unique records and copy them to another location outside the data set.  This is useful when you want to use a filtered list for further analysis. This can also be achieved by using a Pivot Table.  Placing a Field in the Row Labels will ...