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 lesson, we demonstrate a shortcut recipe you can use to remove rows that meet specific criteria quickly.
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.
In this video, we show you three ways to find formulas in a worksheet, including a tricky way to use conditional formatting and a named formula to highlight formulas.
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 blank rows quickly.

Download 200+ Excel Shortcuts

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