|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
February 23rd, 2009, 08:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How could I return to the first row after I finish the last entry?
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 
|
|
#2
February 23rd, 2009, 08:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last entry?
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.
|
|
#3
February 23rd, 2009, 08:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last entry?
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
|
|
#4
February 23rd, 2009, 08:24 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last entry?
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" wrote in message ... 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.
|
|
#5
February 23rd, 2009, 08:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
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
|
|
#6
February 23rd, 2009, 08:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
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.
|
|
#7
February 23rd, 2009, 08:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
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" wrote in message ... 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.
|
|
#8
February 23rd, 2009, 08:40 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
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.
|
|
#9
February 23rd, 2009, 08:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
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" wrote in message ... 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.
|
|
#10
February 23rd, 2009, 09:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
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" wrote in message ... 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.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
