Using MS Excel 2010
I can copy ASCII plain text from a separate text document and paste the text into a cell (I first enter cell edit mode before pasting with Ctrl+V
or Shift+Ins
). After pasting, Excel remains in edit mode. However, when I use my keyboard's arrow keys to navigate the text I just pasted, it instead takes me out of edit mode and moves to the next cell.
This seems to only occur after I've pasted data into the cell. If I go back to the cell after using my arrow key to leave it, I can then press F2
or double-click the cell to re-enter edit mode at which point the arrow keys navigate the text as I originally intended.
How do I stay in this edit mode to use my arrow keys for navigating text immediately after pasting data? I'm very close to eating my keyboard.
EDIT: The behavior I'm describing only occurs when you enter edit mode the first time (to paste the data) by double-clicking with the cursor. Apparently if I enter edit mode with F2
the first time, I don't have this irritating behavior. If this turns out to be the only solution, I'll add it as the answer.
F2
is unexpected