Keyboard shortcut to go to first worksheet in workbook?

Is there a keyboard shortcut that will go to the first worksheet in a
workbook? I can use the mouse to click on the double arrow left, but
some activities aren't as efficient when my hands are on the keyboard.

I use the first worksheet as an index listing all the worksheets in
the workbook with hyperlinks to them. It works well to keep up with
update progress.

Thanks!

Don S

Hi Don,
You would have to make your own shortcut
http://www.mvps.org/dmcritchie/excel/install.htm

Sub GoToFirstSheet()
'David McRitchie, 2006-01-27
On Error Resume Next
Sheets(1).Select
End Sub

More GoToStuff (goes with various web pages)
http://www.mvps.org/dmcritchie/excel/code/gotostuff.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Don S" <[email protected]> wrote in message news:[email protected]...
> Is there a keyboard shortcut that will go to the first worksheet in a
> workbook? I can use the mouse to click on the double arrow left, but
> some activities aren't as efficient when my hands are on the keyboard.
>
> I use the first worksheet as an index listing all the worksheets in
> the workbook with hyperlinks to them. It works well to keep up with
> update progress.
>
> Thanks!
>
> Don S

On Fri, 27 Jan 2006 13:26:55 -0500, "David McRitchie"
<[email protected]> wrote:

>Hi Don,
>You would have to make your own shortcut
> http://www.mvps.org/dmcritchie/excel/install.htm
>
>Sub GoToFirstSheet()
>'David McRitchie, 2006-01-27
> On Error Resume Next
> Sheets(1).Select
>End Sub
>
>More GoToStuff (goes with various web pages)
> http://www.mvps.org/dmcritchie/excel/code/gotostuff.txt
>---
>HTH,
>David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
>My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
>Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
>"Don S" <[email protected]> wrote in message news:[email protected]...
>> Is there a keyboard shortcut that will go to the first worksheet in a
>> workbook? I can use the mouse to click on the double arrow left, but
>> some activities aren't as efficient when my hands are on the keyboard.
>>
>> I use the first worksheet as an index listing all the worksheets in
>> the workbook with hyperlinks to them. It works well to keep up with
>> update progress.
>>
>> Thanks!
>>
>> Don S
>

Thanks David,

...also for the "go to the right of the current row". I've needed the
opposite of "Home" in this same monthly update.

Don S

Don,

you could have a hyperlink in every sheet which points back to your
index sheet.

Pete