Is there a keyboard shortcut to directly go to first/last worksheet in Microsoft Excel without cycling through all with Ctrl+PgUp/PgDn?
If you're up for inserting your own VBA, these two macros will do this. Insert these into a standard code module. See How do I add VBA in MS Office? for detailed guidance. The short version: type Alt+F11 to open the VBA editor, then select "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 the hotkey you want to use. (It must be Ctrl + a letter.) 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 will be available at all times in all workbooks.
As of Excel 2010 there is no direct shortcut for jumping to the first/last worksheet:
An alternative method would be to use the Go To dialog box. Hit F5 and enter:
This will move your selection to cell A1 in sheet named Sheet2.