Pinterest Pixel

Go To Blanks

The Go To Special tool within Excel is a must for any serious Excel user as it... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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 workbookGo-To-Blanks.xlsx

 

STEP 1: Select the entire table containing your data

Go To Blanks

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

Go To Blanks

STEP 3: Select Blanks and click OK
Go To Blanks

STEP 4: Now we have the blank rows selected

Go To Blanks

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

Go To Blanks

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

Go To Blanks

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

Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!