Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles SELECT SPECIAL How to the Display ‘Go To’ Dialog Box in Excel

How to the Display ‘Go To’ Dialog Box in Excel

Excel offers some great keyboard shortcuts to make life easier for its users. The ‘Go To’ dialog box is one such example. We can use the ‘Go To’ box to select cells of a certain type very quickly. In this tutorial, we will learn how to use the ‘Go To’ dialog box in Excel.

Figure 1. Example of how to Display ‘Go To’ Dialog Box in Excel

Keyboard Shortcut

  • Ctrl + G (Windows)
  • + G (Mac)

Process

The ‘Go To’ box lets us go to an address or named range. It has a ‘Special’ button. It allows us to select special cells, like blanks, cells with constants or formulas and a few more.  We can use the Ctrl and G or the F5 button in Windows to open the ‘Go To’ dialog box. In Mac, we can use the ^ and G or the Fn and F5 button to open the box.

Setting Up Data

The following example uses a student information database. Column A, B and C has the student names, Class and ages. The classes have named range of their owns.

Figure 2. The Sample Data Set

To go to grade 6 with the ‘Go To’ dialog box, we need to:

  • Press Ctrl + G.
  • This will open the ‘Go To’ dialog box.
  • From the list select Grade_6.

Figure 3. The ‘Go To’ Dialog Box

  • Press OK.

Figure 4. The Final Result

This will move the selection to the students of grade 6.

Notes

  • The ‘Go To’ dialog box also covers special cells.

Figure 5. The Special Segment of the ‘Go To’ Dialog Box

  • We can check blank cells, constants, formulas and other special cells with the ‘Go To’ dialog box.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc