How could I return to the first row after I finish the last entry?

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

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 said:
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
Click to expand...

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.
 
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.
 
Thank you.

Glenn said:
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.
Click to expand...
 
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....
 
Thank you.

Glenn said:
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.
Click to expand...
 
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.
 
It works.
Thank you, Luke.

Luke M said:
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!*
Click to expand...
 
Hi,

And to follow-up on Rick's comment. The Ctrl+Up Arrow key only works if
there is solid data or all the rows are empty. As an alternative click in
the Name Box on the left side of the Formula Bar and type in the cell address
for the current column-row 1, for example, if you are in z1000 you type in Z1
and press Enter.
 
Thank you.

Shane Devenshire said:
Hi,

And to follow-up on Rick's comment. The Ctrl+Up Arrow key only works if
there is solid data or all the rows are empty. As an alternative click in
the Name Box on the left side of the Formula Bar and type in the cell address
for the current column-row 1, for example, if you are in z1000 you type in Z1
and press Enter.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire
Click to expand...
 
Back
Top