keystroke to go to first worksheet cell from anywhere in notebook

[sheepranch]

Looking for a shortcut keystroke that would place me back to the A1 cell of
the 1st worksheet from anywhere in the notebook. I know that I can get to
that point by using "control+page up". Quatro Pro spoiled me by letting me
use "Control+Home"

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

[JLatham]

I don't think there's a shortcut key combination to do that. You can use
[Ctrl]+[PageUp] to move to the previous page to the left in a book. Repeat
to move through all pages until you get to the first one.

You can use the Excel Help feature, topic Excel shortcut and function keys
to get a complete listing of the documented shortcuts. I didn't see what you
are asking for in it, but may have missed it.

"sheepranch" wrote:

> Looking for a shortcut keystroke that would place me back to the A1 cell of
> the 1st worksheet from anywhere in the notebook. I know that I can get to
> that point by using "control+page up". Quatro Pro spoiled me by letting me
> use "Control+Home"
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

[Steel Monkey]

If you want to create a shortcut to go to A1 in your first worksheet why dont you just record a macro with a shortcut key assigned to it and select your first worksheet and select cell A1?

The macro would end up looking something like this :

Sub gohome()
Worksheets("Sheet1").Activate
Range("A1").Select
End Sub

[Ragdyer]

This is not keystrokes, but,
FWIW
Create a named range!

Click in Sheet1 A1,
Click in name box,
Type in something short, like
top
Hit <Enter>

Now, from *any* sheet, click in the name box and click on "top",
And you're there!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"sheepranch" <[email protected]> wrote in message
news:[email protected]...
> Looking for a shortcut keystroke that would place me back to the A1 cell
> of
> the 1st worksheet from anywhere in the notebook. I know that I can get to
> that point by using "control+page up". Quatro Pro spoiled me by letting me
> use "Control+Home"
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

[sheepranch]

Thanks for the info. I figured that out. I was hoping that there was a less
cumbersome way of getting back to worksheet 1, A1

"JLatham" wrote:

> I don't think there's a shortcut key combination to do that. You can use
> [Ctrl]+[PageUp] to move to the previous page to the left in a book. Repeat
> to move through all pages until you get to the first one.
>
> You can use the Excel Help feature, topic Excel shortcut and function keys
> to get a complete listing of the documented shortcuts. I didn't see what you
> are asking for in it, but may have missed it.
>
> "sheepranch" wrote:
>
> > Looking for a shortcut keystroke that would place me back to the A1 cell of
> > the 1st worksheet from anywhere in the notebook. I know that I can get to
> > that point by using "control+page up". Quatro Pro spoiled me by letting me
> > use "Control+Home"
> >
> > ----------------
> > This post is a suggestion for Microsoft, and Microsoft responds to the
> > suggestions with the most votes. To vote for this suggestion, click the "I
> > Agree" button in the message pane. If you do not see the button, follow this
> > link to open the suggestion in the Microsoft Web-based Newsreader and then
> > click "I Agree" in the message pane.
> >
> > http://www.microsoft.com/office/comm...heet.functions

[sheepranch]

Thanks. I'll try making a macro...never done that before. Would your
suggested macro be a "generic" macro for any notebook I was in or would I
have to make a macro for each separate notebook?

"Steel Monkey" wrote:

>
> If you want to create a shortcut to go to A1 in your first worksheet why
> dont you just record a macro with a shortcut key assigned to it and
> select your first worksheet and select cell A1?
>
> The macro would end up looking something like this :
>
> Sub gohome()
> Worksheets("Sheet1").Activate
> Range("A1").Select
> End Sub
>
>
> --
> Steel Monkey
> ------------------------------------------------------------------------
> Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
> View this thread: http://www.excelforum.com/showthread...hreadid=559114
>
>

[Gord Dibben]

The proper term for an Excel file is Workbook, not notebook.

If you want a macro to be available for all open workbooks, record it to your
Personal Macro Workbook.

Tools>Macro>Record New Macro. In the dialog that opens, select Person Macro
Workbook from the "store macro in" drop-down.

This workbook is named Personal.xls and is created automatically and stored by
Excel in your XLSTART folder.

This file will open up whenever you start a session of Excel.

When it opens, you can click on Windw>Hide and hide it.

Save it when asked and it will open hidden from then on.

For more on Personal.xls see Help on that subject.


Gord Dibben MS Excel MVP


On Thu, 6 Jul 2006 20:50:01 -0700, sheepranch
<[email protected]> wrote:

>Thanks. I'll try making a macro...never done that before. Would your
>suggested macro be a "generic" macro for any notebook I was in or would I
>have to make a macro for each separate notebook?
>
>"Steel Monkey" wrote:
>
>>
>> If you want to create a shortcut to go to A1 in your first worksheet why
>> dont you just record a macro with a shortcut key assigned to it and
>> select your first worksheet and select cell A1?
>>
>> The macro would end up looking something like this :
>>
>> Sub gohome()
>> Worksheets("Sheet1").Activate
>> Range("A1").Select
>> End Sub
>>
>>
>> --
>> Steel Monkey
>> ------------------------------------------------------------------------
>> Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
>> View this thread: http://www.excelforum.com/showthread...hreadid=559114
>>
>>

[sheepranch]

Thanks for the info. I'll try it.

"Gord Dibben" wrote:

> The proper term for an Excel file is Workbook, not notebook.
>
> If you want a macro to be available for all open workbooks, record it to your
> Personal Macro Workbook.
>
> Tools>Macro>Record New Macro. In the dialog that opens, select Person Macro
> Workbook from the "store macro in" drop-down.
>
> This workbook is named Personal.xls and is created automatically and stored by
> Excel in your XLSTART folder.
>
> This file will open up whenever you start a session of Excel.
>
> When it opens, you can click on Windw>Hide and hide it.
>
> Save it when asked and it will open hidden from then on.
>
> For more on Personal.xls see Help on that subject.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Thu, 6 Jul 2006 20:50:01 -0700, sheepranch
> <[email protected]> wrote:
>
> >Thanks. I'll try making a macro...never done that before. Would your
> >suggested macro be a "generic" macro for any notebook I was in or would I
> >have to make a macro for each separate notebook?
> >
> >"Steel Monkey" wrote:
> >
> >>
> >> If you want to create a shortcut to go to A1 in your first worksheet why
> >> dont you just record a macro with a shortcut key assigned to it and
> >> select your first worksheet and select cell A1?
> >>
> >> The macro would end up looking something like this :
> >>
> >> Sub gohome()
> >> Worksheets("Sheet1").Activate
> >> Range("A1").Select
> >> End Sub
> >>
> >>
> >> --
> >> Steel Monkey
> >> ------------------------------------------------------------------------
> >> Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
> >> View this thread: http://www.excelforum.com/showthread...hreadid=559114
> >>
> >>
>
>