Some methodssuch as theGo Tocommandcan be accessed using keyboard shortcut key combinations.
These instructions should work for all versions of Excel for Windows.
Any minor differences between versions are called out in the steps.
Worksheet tabs are located at the bottom-left of the Excel window.
To move to the right, press and hold down theCtrlkey on the keyboard.
Press and release thePgDnkey on the keyboard.
To move another sheet to the right press and release thePgDnkey a second time.
Lifewire
To move to the left, press and hold down theCtrlkey on the keyboard.
Press and release thePgUpkey on the keyboard.
To move another sheet to the left press and release thePgUpkey a second time.
Lifewire
Select theHometab at the top of Excel.
If you don’t see it, select theEditmenu.
ChooseFind & Selectfrom theEditinggroup.
Or, if you used theEditmenu, chooseFind.
Choose theGo To…option.
jot down in the destinationcell referencein theReferenceline at the bottom of the dialog box.
ClickOKor press theEnterkey on the keyboard.
The result is that theactive cellhighlight jumps to the cell reference that was entered in the dialog box.
Cell references are stored in the dialog box as long as a workbook remains open.
Once it is closed, the stored list of cell references in theGo Todialog box is deleted.
Use the exclamation point (!
Normal operation requires clicking on theName Boxwith the mouse.
hit theName Boxabovecolumn Ato highlight the cell reference of the active cell.
punch in in thecell referenceof the desired destination.
Press theEnterkey on the keyboard.
The black box that surrounds the active cell should jump to the newly selected active cell.
FAQ
To move to the next worksheet, pressControl+Page DownorOption+Right arrow.
To move to the previous sheet, pressControl+Page DownorOption+Left arrow.
Togroup worksheets in Excel, press and holdCtrl> select each worksheet tab to group.
It’s best to group worksheets that have the same formatting.
