The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    excel: prevent cursor keys to exit edit mode

    Discussion in 'Windows OS and Software' started by Sir Punk, Sep 14, 2010.

  1. Sir Punk

    Sir Punk Notebook Deity

    Reputations:
    0
    Messages:
    1,061
    Likes Received:
    3
    Trophy Points:
    56
    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
     
  2. Sir Punk

    Sir Punk Notebook Deity

    Reputations:
    0
    Messages:
    1,061
    Likes Received:
    3
    Trophy Points:
    56
    sorry I should have said it, I am using the 2007, it happens with two different versions. is this a bug or a design choice or an option somewhere?

    I can't believe nobody noticed this, I can't find any info around.
     
  3. FXi

    FXi Notebook Deity

    Reputations:
    345
    Messages:
    1,054
    Likes Received:
    130
    Trophy Points:
    81
    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.