Go Back

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:
Here are some problems that our users have asked and received explanations on

How to develop searchable look up dialog box
Solved by I. S. in 20 mins
Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name.
Solved by I. A. in 12 mins
VBA wizard dialog box for easier use and management of spreadsheet
Solved by E. W. in 22 mins

Leave a Comment

avatar