Open Go To Dialog Box in Excel
The Go To dialog box allows you to quickly jump to a specific cell, range, named range, or special location in an Excel worksheet. It is one of the most powerful navigation tools in Excel.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + G or F5 |
Cmd + G or Fn + F5 |
What Does This Shortcut Do?
Pressing this shortcut opens the Go To dialog box, where you can enter a cell reference, range, or select named ranges. It also provides access to the Go To Special feature.
How to Use the Shortcut
- Press Ctrl + G or F5
- The Go To dialog box will appear
- Type a cell address (for example, A100)
- Press Enter to jump instantly
Tips & Best Practices
- Use Go To Special to select blanks, formulas, constants, or visible cells
- Jump quickly between distant parts of large worksheets
- Works across worksheets and named ranges
FAQ
- Q: What is Go To Special?
- It allows you to select specific cell types such as blanks, formulas, comments, or visible cells.
- Q: Can I use Go To across worksheets?
- Yes, you can reference another sheet using SheetName!Cell (for example, Sheet2!A1).
- Q: Is Ctrl + G different from F5?
- No, both shortcuts open the same Go To dialog box.