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 ...

How to Program an Excel ... Go to the "Data" tab. Click "Refresh All" in the "Connections" group and select "Connection Properties" in the drop-down list. The "Connection Properties" dialog box ...

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 .