Switch to first/last worksheet directly with keyboard

Question

Is there a keyboard shortcut to directly go to first/last worksheet in Microsoft Excel without cycling through all with Ctrl+PgUp/PgDn?

Answer 1

But if you're up for inserting your own VBA, these two macro will do this. Insert these into a standard code module (Ctrl-F11 to open the editor, then Insert > Module)

Sub JumpFirst()
    Sheets(1).Activate
End Sub

Sub JumpLast()
    Sheets(Sheets.Count).Activate
End Sub

Then close the editor. Then on the Developer tab, click Macros and click on one of these new macros, click on OPTIONS and set hotkey you want to use. Repeat with the other macro.

Now you have to hotkeys to jump to first and last.

If the VBAProject you insert the module in the PERSONAL.XLS workbook, then these macros would be available at all times in all workbooks.

Answer 2

As of Excel 2010 there is no direct shortcut for jumping to the first/last worksheet:

• List of keyboard shortcuts in Excel 2010

An alternative method would be to use the Go To dialog box. Hit F5 and enter:

SHEET_NAME!CELL_NO

Example:

Sheet2!A1

This will move your selection to cell A1 in sheet named Sheet2.