In MS Excel, the GO TO option is used to directly go to any existing name range within the workbook. With the Go To option users can go to any of the name range that they have in any of the sheets in the current workbook very quickly and without switching the tabs.
So, for users who work on large data sets with multiple name ranges and data in multiple sheets, the Go To option is best to switch between name ranges very quickly.
Keyboard Shortcut to Open Go To Option in the Excel
Ctrl + G
Steps to Open Go To Option Using Keyboard Shortcut
- First, go to the current workbook and simply press the “Ctrl + G” keys together and you will get the “Go To” dialog box opened.
- Now, select the name range out of the defined ones within the current workbook, where you want to go, and then press enter and you will directly reach that name range.