Single-step keyboard shortcut to move to the 1st worksheet tab in Excel

Posted on 2014-08-26
Last Modified: 2014-09-20

When using multiple worksheets (tabs) in an Excel workbook, the only tab navigation shortcuts I'm aware of are the following:

      Ctrl+PgUp  =  move one tab to the left
      Ctrl+PgDn  =  move one tab to the right

Is there a similar keyboard shortcut which, regardless of which tab is active, will move you to the "Home" or furthest left sheet tab?

If that shortcut does not already exist, does anyone know of a good workaround or — if it's not too lengthy — could someone provide me with VBA code to which I could attach a macro hotkey?

Question by:WeThotUWasAToad
    LVL 26

    Accepted Solution

    Create a macro with this line of code and assign to it whichever shortcut you want:

    Open in new window

    LVL 31

    Assisted Solution

    by:Rob Henson
    Alternatively without use of VBA.

    Create a named range on the first sheet with a range name such that it will appear early in an alphabetical list, eg A_1

    You can then press F5 to bring up the list of Named Ranges, select the Named Range and click OK.

    Rob H

    Author Comment

    Thanks for the responses.

    Rob, your solution would seem to require three keystrokes (F5 > select > OK), whereas the solution from MacroShadow (once it is added as code) would seem to require only one (the designated hotkey). Aside from not requiring the "use of VBA", are there any other benefits I'm missing?
    LVL 31

    Expert Comment

    by:Rob Henson
    One benefit of not using VBA is that you maintain the Undo history.  When a macro runs you lose the history.

    Another option with VBA would be still to have the named range and then use this line:

    Application.Goto Reference "RangeName"


    Author Closing Comment

    Thanks for the responses and apologies for the delayed response.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now