Exceljet

Quick, clean, and to the point

Display 'Go To' dialog box

Windows shortcut 
CtrlG
Mac shortcut 
G

The 'Go To' window allows you to go to a named range or an address that you supply. It also has 'Special' button that will allow you to select cells based on several criteria - blank cells, cells that contain constants, cells with formulas, etc. Special is where the real power is. Note that you can also use F5 on Windows and fn F5 on a Mac to display the Go To window.

Related videos

The videos below show how this shortcut can be used.
In this lesson, we demonstrate a shortcut recipe you can use to remove blank rows quickly.
In this video, we'll look at a way to quickly add missing data to a worksheet. It's a simple technique using a very basic formula, and a cool example of relative cell references.
In this lesson, we cover shortcuts you can use to select special cells with Go To Special
In this video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions.
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.