Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
I'm trying to find some way to quickly position the insertion point at the
beginning of a cell when it is edited, rather than at the end. I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
Just click in the formula bar rather than pressing F2 - you decide
where to click. Hope this helps. Pete On Mar 25, 7:49*pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. *I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. *I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
Wow, that was fast! Thanks for the prompt response. Unfortunately, the
contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
Well, if your text is that long you might be better off using Word.
Pete On Mar 25, 8:35*pm, Sue wrote: Wow, that was fast! *Thanks for the prompt response. *Unfortunately, the contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. *So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. *A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. *I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. *I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
F2 then Home will take you to the beginning of the cell text.
Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 13:35:06 -0700, Sue wrote: Wow, that was fast! Thanks for the prompt response. Unfortunately, the contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
Nope - that just takes me to the beginning of the last line of text.
"Gord Dibben" wrote: F2 then Home will take you to the beginning of the cell text. Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 13:35:06 -0700, Sue wrote: Wow, that was fast! Thanks for the prompt response. Unfortunately, the contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
Yep. You're right.
Did not test with wrapped text. Gord On Wed, 26 Mar 2008 07:12:04 -0700, Sue wrote: Nope - that just takes me to the beginning of the last line of text. "Gord Dibben" wrote: F2 then Home will take you to the beginning of the cell text. Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 13:35:06 -0700, Sue wrote: Wow, that was fast! Thanks for the prompt response. Unfortunately, the contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
Pressing F2 and then CTRL-Home takes my cursor to the beginning of a
long paragraph of text in XL 2000. Mind you, my testing might not be completely thorough, as I don't fancy typing in such a long item of text as Sue seems to have. Hope this helps. Pete On Mar 26, 8:51*pm, Gord Dibben <gorddibbATshawDOTca wrote: Yep. *You're right. Did not test with wrapped text. Gord On Wed, 26 Mar 2008 07:12:04 -0700, Sue wrote: Nope - that just takes me to the beginning of the last line of text. "Gord Dibben" wrote: F2 then Home will take you to the beginning of the cell text. Gord Dibben *MS Excel MVP On Tue, 25 Mar 2008 13:35:06 -0700, Sue wrote: Wow, that was fast! *Thanks for the prompt response. *Unfortunately, the contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. *So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. *A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. *I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. *I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
Three cheers for Pete_UK! Hip hip hooray! Hip hip hooray! Hip hip hooray!
Problem solved! And for the record, I don't fancy typing in that much text either. ;-) But when you're keeping a complete historical log, that text has a pesky way of growing and growing and growing... Thanks again for the help folks! Sue "Pete_UK" wrote: Pressing F2 and then CTRL-Home takes my cursor to the beginning of a long paragraph of text in XL 2000. Mind you, my testing might not be completely thorough, as I don't fancy typing in such a long item of text as Sue seems to have. Hope this helps. Pete On Mar 26, 8:51 pm, Gord Dibben <gorddibbATshawDOTca wrote: Yep. You're right. Did not test with wrapped text. Gord On Wed, 26 Mar 2008 07:12:04 -0700, Sue wrote: Nope - that just takes me to the beginning of the last line of text. "Gord Dibben" wrote: F2 then Home will take you to the beginning of the cell text. Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 13:35:06 -0700, Sue wrote: Wow, that was fast! Thanks for the prompt response. Unfortunately, the contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue- Hide quoted text - - Show quoted text - |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position insertion point at beginning of cell when editing
You're welcome, Sue - thanks for feeding back. I'm glad we found a
solution to your problem. Pete On Mar 28, 4:18*pm, Sue wrote: Three cheers for Pete_UK! *Hip hip hooray! *Hip hip hooray! *Hip hip hooray! * Problem solved! And for the record, I don't fancy typing in that much text either. *;-) *But when you're keeping a complete historical log, that text has a pesky way of growing and growing and growing... * Thanks again for the help folks! Sue "Pete_UK" wrote: Pressing F2 and then CTRL-Home takes my cursor to the beginning of a long paragraph of text in XL 2000. Mind you, my testing might not be completely thorough, as I don't fancy typing in such a long item of text as Sue seems to have. Hope this helps. Pete On Mar 26, 8:51 pm, Gord Dibben <gorddibbATshawDOTca wrote: Yep. *You're right. Did not test with wrapped text. Gord On Wed, 26 Mar 2008 07:12:04 -0700, Sue wrote: Nope - that just takes me to the beginning of the last line of text. "Gord Dibben" wrote: F2 then Home will take you to the beginning of the cell text. Gord Dibben *MS Excel MVP On Tue, 25 Mar 2008 13:35:06 -0700, Sue wrote: Wow, that was fast! *Thanks for the prompt response. *Unfortunately, the contents of some of the cells are so large, that the formula bar does not fit in the height of a maximized Excel window. *So, once I click in the formula bar, I have to hold down the up arrow key until I get to the top, then hit the Home key to get to the beginning of the top line. *A little slow when you're trying to capture updates during a meeting... ;-) "Pete_UK" wrote: Just click in the formula bar rather than pressing F2 - you decide where to click. Hope this helps. Pete On Mar 25, 7:49 pm, Sue wrote: I'm trying to find some way to quickly position the insertion point at the beginning of a cell when it is edited, rather than at the end. *I have a spreadsheet where we need to enter a large amount of text into some of the cells (so large that it is necessary to scroll in the cell to see it all), and the only way I can get to the beginning is to use the up arrow key to scroll to the top. *I know that F2 will edit the cell starting at the end - is there an equivalent for starting at the beginning? Thanks, Sue- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why did my Excel insertion point change to a cross? | New Users to Excel | |||
how to change the insertion point color? | Excel Worksheet Functions | |||
decimal point position for less than 1 million | Charts and Charting in Excel | |||
causing macros to run at insertion point | Excel Worksheet Functions | |||
position of decimal point when entering a number ... | Excel Discussion (Misc queries) |