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

Tip: 23 formula tips to save you time today
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list. We trust that you can rewind the video as needed :)
Tip: How to check and debug a formula with F9
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.
Tip: How to quickly fill in missing data
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
Tip: How to quickly fill in missing data - part 2
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.
Tip: Shortcuts Recipe Remove Blank Rows
In this video, we'll look at a simple shortcut recipe for removing thousands of blank rows in a large set of data. Shortcut recipes are just a series of shortcuts you perform in a certain sequence to solve a specific problem.
Just a fantastic site. I have learned a ton in a short period. Your videos shaved about 4 hours off an assignment for work this past week. -Kurt
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course