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.

Double-click the line to open the Go To dialog box, select a worksheet and cell if more than one option is in the Go To: list and then click the "OK" button to go to the precedent worksheet and ...

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 .