editing text within a cell before moving to a new cell

  • Thread starter Thread starter nicholasburger
  • Start date Start date
N

nicholasburger

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
 
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
 
Thanks! I never thought of pressing F2 while entering text, that works
perfectly.

-Nick
 
Somrtimes the most obvious is hidden because we try to look for the more
complex.

Thanks for the feedback.


Gord
 
Back
Top