IF I have a big long worksheet data to enter, how could I return to the first
row when I finish the last entry at the bottom of the worksheet?

Thanking you in advance for your help.

Grace

Grace wrote:
> IF I have a big long worksheet data to enter, how could I return to the first
> row when I finish the last entry at the bottom of the worksheet?
>
> Thanking you in advance for your help.
>
> Grace

In the help file under "Keyboard shortcuts" / "Keys for workbooks and
worksheets" / "Move and scroll within worksheets":

CTRL+HOME Move to the beginning of the worksheet.

Try pressing Ctrl+Home
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Grace" wrote:

> IF I have a big long worksheet data to enter, how could I return to the first
> row when I finish the last entry at the bottom of the worksheet?
>
> Thanking you in advance for your help.
>
> Grace

To follow up on Glenn's advice...

Ctrl+Home takes you to cell A1. If you just want to go to Row 1 in the same
column you are currently in, you can do that with Ctrl+UpArrow.

--
Rick (MVP - Excel)


"Glenn" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Grace wrote:
>> IF I have a big long worksheet data to enter, how could I return to the
>> first row when I finish the last entry at the bottom of the worksheet?
>>
>> Thanking you in advance for your help.
>>
>> Grace
>
> In the help file under "Keyboard shortcuts" / "Keys for workbooks and
> worksheets" / "Move and scroll within worksheets":
>
> CTRL+HOME Move to the beginning of the worksheet.

Thank you.

"Luke M" wrote:

> Try pressing Ctrl+Home
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "Grace" wrote:
>
> > IF I have a big long worksheet data to enter, how could I return to the first
> > row when I finish the last entry at the bottom of the worksheet?
> >
> > Thanking you in advance for your help.
> >
> > Grace

Thank you.

"Glenn" wrote:

> Grace wrote:
> > IF I have a big long worksheet data to enter, how could I return to the first
> > row when I finish the last entry at the bottom of the worksheet?
> >
> > Thanking you in advance for your help.
> >
> > Grace
>
> In the help file under "Keyboard shortcuts" / "Keys for workbooks and
> worksheets" / "Move and scroll within worksheets":
>
> CTRL+HOME Move to the beginning of the worksheet.
>

Thank you.

And is it possible to create a button at the end of the worksheet, so I
could back to the top by clicking it?
Please....

"Rick Rothstein" wrote:

> To follow up on Glenn's advice...
>
> Ctrl+Home takes you to cell A1. If you just want to go to Row 1 in the same
> column you are currently in, you can do that with Ctrl+UpArrow.
>
> --
> Rick (MVP - Excel)
>
>
> "Glenn" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Grace wrote:
> >> IF I have a big long worksheet data to enter, how could I return to the
> >> first row when I finish the last entry at the bottom of the worksheet?
> >>
> >> Thanking you in advance for your help.
> >>
> >> Grace
> >
> > In the help file under "Keyboard shortcuts" / "Keys for workbooks and
> > worksheets" / "Move and scroll within worksheets":
> >
> > CTRL+HOME Move to the beginning of the worksheet.
>
>

Thank you.

"Glenn" wrote:

> Grace wrote:
> > IF I have a big long worksheet data to enter, how could I return to the first
> > row when I finish the last entry at the bottom of the worksheet?
> >
> > Thanking you in advance for your help.
> >
> > Grace
>
> In the help file under "Keyboard shortcuts" / "Keys for workbooks and
> worksheets" / "Move and scroll within worksheets":
>
> CTRL+HOME Move to the beginning of the worksheet.
>

Go to Tools-Macro-Record Macro. Give the macro a name, then start recording.
Press Ctrl+Home
Stop recording
Open the 'Forms' toolbar. Create a button & assign the macro you just wrote.
OR
Draw any shape from the drawing toolbar (like a smiley face!) and then right
click, assign macro.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Grace" wrote:

> Thank you.
>
> And is it possible to create a button at the end of the worksheet, so I
> could back to the top by clicking it?
> Please....
>
> "Rick Rothstein" wrote:
>
> > To follow up on Glenn's advice...
> >
> > Ctrl+Home takes you to cell A1. If you just want to go to Row 1 in the same
> > column you are currently in, you can do that with Ctrl+UpArrow.
> >
> > --
> > Rick (MVP - Excel)
> >
> >
> > "Glenn" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> > > Grace wrote:
> > >> IF I have a big long worksheet data to enter, how could I return to the
> > >> first row when I finish the last entry at the bottom of the worksheet?
> > >>
> > >> Thanking you in advance for your help.
> > >>
> > >> Grace
> > >
> > > In the help file under "Keyboard shortcuts" / "Keys for workbooks and
> > > worksheets" / "Move and scroll within worksheets":
> > >
> > > CTRL+HOME Move to the beginning of the worksheet.
> >
> >

It works.
Thank you, Luke.

"Luke M" wrote:

> Go to Tools-Macro-Record Macro. Give the macro a name, then start recording.
> Press Ctrl+Home
> Stop recording
> Open the 'Forms' toolbar. Create a button & assign the macro you just wrote.
> OR
> Draw any shape from the drawing toolbar (like a smiley face!) and then right
> click, assign macro.
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "Grace" wrote:
>
> > Thank you.
> >
> > And is it possible to create a button at the end of the worksheet, so I
> > could back to the top by clicking it?
> > Please....
> >
> > "Rick Rothstein" wrote:
> >
> > > To follow up on Glenn's advice...
> > >
> > > Ctrl+Home takes you to cell A1. If you just want to go to Row 1 in the same
> > > column you are currently in, you can do that with Ctrl+UpArrow.
> > >
> > > --
> > > Rick (MVP - Excel)
> > >
> > >
> > > "Glenn" <(E-Mail Removed)> wrote in message
> > > news:%(E-Mail Removed)...
> > > > Grace wrote:
> > > >> IF I have a big long worksheet data to enter, how could I return to the
> > > >> first row when I finish the last entry at the bottom of the worksheet?
> > > >>
> > > >> Thanking you in advance for your help.
> > > >>
> > > >> Grace
> > > >
> > > > In the help file under "Keyboard shortcuts" / "Keys for workbooks and
> > > > worksheets" / "Move and scroll within worksheets":
> > > >
> > > > CTRL+HOME Move to the beginning of the worksheet.
> > >
> > >