Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

In Excel 2013, hold down ctrl when clicking the arrow buttons to scroll to the first/last sheet. I'm not sure about previous versions of Excel.

share|improve this answer
Just to clarify, the answer below. Hold Ctrl and click the "next worksheet" arrow icon on the screen, or "previous worksheet" arrow icon. Not the arrow keys on the keyboard. So no short-cut key I can find unfortunately. – user374439 Oct 2 '14 at 7:47

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()
End Sub

Sub JumpLast()
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.

share|improve this answer

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.

share|improve this answer

You must log in to answer this question.

protected by slhck Oct 2 '14 at 9:58

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .