associatesple.blogg.se

This will open the ‘ Go To ’ dialog box.To go to grade 6 with the ‘Go To’ dialog box, we need to: The classes have named range of their owns. Column A, B and C has the student names, Class and ages. The following example uses a student information database. In Mac, we can use the ^ and G or the Fn and F5 button to open the box. We can use the Ctrl and G or the F5 button in Windows to open the ‘Go To’ dialog box. It allows us to select special cells, like blanks, cells with constants or formulas and a few more. The ‘Go To’ box lets us go to an address or named range. Example of how to Display ‘Go To’ Dialog Box in Excel Keyboard Shortcut

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