| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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
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
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
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. |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
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 "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. |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How could I return to the first row after I finish the last en
Thank you.
"Shane Devenshire" wrote: 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 "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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula: Return last entry in column | Excel Discussion (Misc queries) | |||
| Finish Spreadsheet | Excel Discussion (Misc queries) | |||
| Return entry in column above/below cell | Excel Worksheet Functions | |||
| Function to return last entry in a column series? | Excel Worksheet Functions | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
Linear Mode
