Pinterest Pixel

Go To Blanks

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

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Go To Blanks | MyExcelOnline Go To Blanks | MyExcelOnline

Go To Blanks

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 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 it
Go To Blanks | MyExcelOnline Go To Blanks | MyExcelOnline
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.

See also  Drop Down Menu In Your Excel Table

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!

Share to...