It can be difficult to go between your tables, named ranges, etc., when your Excel file has several tabs.
In that case, Excel’s GO TO function comes in very handy.
You can do this pretty quickly if you know how to open the “Go To” dialog box.
In this short article, I’ll show you how to use keyboard shortcuts to quickly open the “Go To” dialog box in Excel.
Shortcut to Open ‘Go To’ Dialog Box in Excel
Below are the keyboard shortcuts to open the ‘Go To’ dialog box in Excel:
CTRL + G
How to Use the Keyboard Shortcut
Below are the steps to use the F5 shortcut to open the Go To dialog box:
- Open the Excel file.
- Press F5.
For this to work, you don’t need to select any cell or range. Also, note that this will not work if you are in the edit mode in the cell. You will have to come out of the edit mode and then use this shortcut.
You cannot use the F5 if the function keys are locked. Then, while holding down the Fn key, you need to press F5.
If you decide to use the Control G shortcut, you can use the below steps:
- Open the Excel file.
- Press “G” while holding the CTRL key.
Important Things to Know
- You need to only press the F5 key (If function keys are locked, press the Fn key also). The window size of the selected workbook window will be restored if you press F5 while holding down the CTRL key.
- Once you have opened the Go To Special dialog box, you can then open the Go To Special dialog box by using ALT + S (hold the ALT key and then press the S key), or by clicking on the Special button.
Some Smart Ways to Use Go To Special Dialog Box
The ‘Go To’ dialog box is a powerful tool that can help you navigate and select cells in your worksheets quickly.
Here are a few other ways you can use this tool to enhance your Excel experience:
Navigating Through Worksheets
The ‘Go To’ dialog box can help you navigate through your worksheets quickly.
For example, if you have a large worksheet with many rows and columns, you can use the ‘Go To’ dialog box to jump to a specific cell or range of cells.
To do this, press Ctrl + G or F5 to open the ‘Go To’ dialog box. Then, enter the cell reference or range of cells you want to go to in the Reference box and click OK.
You will be taken directly to the cell or range of cells you specified.
Selecting Non-Adjacent Cells
The ‘Go To’ dialog box can also help you select non-adjacent cells in your worksheet. To do this, press Ctrl + G or F5 to open the ‘Go To’ dialog box.
Then, enter the cell references or ranges of cells you want to select in the Reference box, separating each reference or range with a comma.
For example, if you want to select cells A1, C1, and E1, you would enter A1,C1,E1 in the Reference box. Then, click OK to select the specified cells.
You can also use the ‘Go To’ dialog box to select cells based on specific criteria, such as blank cells, cells with formulas, or cells with constants.
To do this, click the Special button in the ‘Go To’ dialog box and select the criteria you want to use. Then, click OK to select the specified cells.
Other Excel shortcuts you may also like:
- Excel Keyboard Shortcuts
- Open Find and Replace in Excel
- Shortcut to Open VBA Editor in Excel
- Format Painter in Excel (Shortcut)
- Toggle Between Cell References (Absolute/Relative/Mixed) Shortcut
Other Excel Tutorials You May Also Like: