The Go To dialog box will open. In the Reference section, enter the Workbook sheet you wish to switch to, for example, Sheet5!B3, then click OK , and it will switch to sheet 5.

Quick tip: You can get to the Go to Special dialog box by pressing F5 on your keyboard to open the Go To dialog box, and then clicking the Special button in the bottom left corner. 4. A pop-up box ...

F3: If a name is defined, displays the Paste Name dialog box. F4 : Repeats the last action and toggles between relative, absolute and mixed references when entering a formula. F5 : Shows the Go To ...

Inside the dialog box in the Reference box, enter a cell or cell range. Click OK ; it will go to the cell or cell range you entered. Read : Microsoft Excel Tutorial for Beginners .