Single-step keyboard shortcut to move to the 1st worksheet tab in Excel
Posted on 2014-08-26
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?