Welcome to my new series: Go To Special’s Hidden Treasures. If you aren’t familiar with Go To Special, it’s an Excel tool used to select specific cells in a worksheet. First up in the series: how to delete all blank rows.
One of the most common issues with importing data is blank (or null) values within the data table. Instead of deleting blank rows individually, you can delete them all at once using Go To Special.
First, use CTRL+G to select all the blank cells within the data table, hit the Special button, select “Blanks,” and hit OK. Then, to delete all blank rows, just press CTRL+- to open the Delete dialog box. Select “Shift cells up” and hit OK once more.
And there you go! Hundreds of blank rows deleted at once, all thanks to Go To Special. Tune in next time for part two of Go To Special’s Hidden Treasures.
Btw…If you enjoyed this productivity tip and want to work even faster in Excel, I created a productivity course that covers all of Excel’s shortcuts and productivity tips. It includes five modules plus a *bonus* fan-favorite module, shortcut flashcards, Excel Dictionary’s best-selling shortcut merch, and more! Make sure to join the waitlist so you don’t miss the launch (and so you can lock in the lowest possible price)!
