Hi -
Does anyone know how to move back and forth through text WITHIN a cell
when first entering text in that cell? (If this is unclear, it's
because I'm not sure quite the best way to explain it). Basically,
imagine I type two words into a cell and realize I've mispelled the
first one. If I hit the left arrow key (ostensibly to move back to the
first word) excel will move me back an entire cell. I then have to (1)
right-arrow over to the original cell, (2) hit F2, and (3) then scroll
back to the misspelled word.
Is there any key modifier I can use to skip directly to (3) without
leaving the cell first? I realize I could use the mouse to move back,
but the idea is to save time/keystrokes if at all possible.
Thanks in advance,
Nick
Gord Dibben - 03 Oct 2006 17:29 GMT
In order to move through the cell using the arrow keys you must be in Edit mode.
When you make a mistake and wish to arrow back a couple of letters, hit F2 then
move with the arrow keys.
OR just hit F2 before you start entering text.
Gord Dibben MS Excel MVP
>Hi -
>
[quoted text clipped - 13 lines]
>Thanks in advance,
>Nick
nicholasburger@gmail.com - 03 Oct 2006 18:10 GMT
Thanks! I never thought of pressing F2 while entering text, that works
perfectly.
-Nick
Gord Dibben - 04 Oct 2006 00:28 GMT
Somrtimes the most obvious is hidden because we try to look for the more
complex.
Thanks for the feedback.
Gord
>Thanks! I never thought of pressing F2 while entering text, that works
>perfectly.
>
>-Nick