I use excel heavily but one of the most annoying things is when I am typing text, after pressing F2 and going into edit mode, and then I pause typing for a few seconds, then when I press a cursor key to go back in the text, the program exits edit mode and the pointer moves to another cell, either up, left, or right.
It just drives me crazy, i can't find any option to stop this. please help.
I hope I made this clear enough.
thanks
-
I can't believe nobody noticed this, I can't find any info around. -
I don't know if I didn't pause long enough, but it didn't do it for me in 2007. Do you have any addon's that might be giving you this trouble?
On a "how to get around it" thought I figure if you've waited a couple of moments in F2 edit, just hit Esc F2 and bounce out and back into the edit mode again and then start doing what you were aiming to do. Yes, that's a 2 stroke workaround, but it would at least keep you in the same cell and put you right back where you were (at least in a basic edit mode sense).
I don't think I have the time to go through and compare 5 billion settings, but I have nothing more than the base install of 2007 (haven't had time to customize it on this machine yet) and it did not do that for me.
excel: prevent cursor keys to exit edit mode
Discussion in 'Windows OS and Software' started by Sir Punk, Sep 14, 2010.