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 demonstrate this shortcut.
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 demonstrate a shortcut recipe you can use to remove blank rows quickly.
In this lesson, we cover shortcuts you can use to select special cells with Go To Special
In this brief video, we look at how to debug a formula using the F9 key. If you work with formulas a lot, this is one of the most useful skills you can learn.
In this lesson, we demonstrate a shortcut recipe you can use to remove rows that meet specific criteria quickly.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas