Changing the position of the cursor after data entry.
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Changing the position of the cursor after data entry.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I know this can be done, but I forget where to go.
    Is there a way of having the cell pointer stay in the cell after you enter data?
    Rather than have it jump a cell down or a cell to the right.

    Thanks
    Zac

  2. #2
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    CONTROL + ENTER
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  3. #3
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I believe you mean Alt+Enter.

    This will put a return in whatever cell you are in instead of moving to the next cell.
    Kristy

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I disagree.

    If you enter data in a cell, and hit Enter,
    I want the cursor or pointer to stay in that
    cell and not advance to the cell below or
    the cell to the right.

    I'm writing a macro for the person upstairs.
    My keystrokes doesn't move the cell pointer to the cell below or to the right, but theirs does. So when the macro executes on her system, the data ends up in different cells because after she keystrokes data, her pointer jumps to the next cell down.

    How do I change her settings to correct that problem?

    Zac

  5. #5
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    CONTROL + ENTER works for me (Excel 97). After entering data, I hit that combination and the cell remains selected.

    ALT + ENTER means inserting a paragraph within the cell.

    _________________
    - old, slow, and confused
    ... but at least I'm inconsistent -

    [ This Message was edited by: shades on 2002-04-08 12:26 ]

  6. #6
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go to TOOLS > OPTIONS > EDIT tab, then uncheck box "Move Selection after enter"
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  7. #7
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-08 12:09, Zac wrote:
    I disagree.

    If you enter data in a cell, and hit Enter,
    I want the cursor or pointer to stay in that
    cell and not advance to the cell below or
    the cell to the right.

    I'm writing a macro for the person upstairs.
    My keystrokes doesn't move the cell pointer to the cell below or to the right, but theirs does. So when the macro executes on her system, the data ends up in different cells because after she keystrokes data, her pointer jumps to the next cell down.

    How do I change her settings to correct that problem?

    Zac
    Tools>Options>Edit
    Adjust the Move selection after Enter to the direction you want.

    Are you using Send Keys in your routine? Post your code so it can be rewritten to eliminate the problem. Your procedure needs to work correctly regardless of the settings.

    Others may disagree, but I feel it is best to avoid send keys unless there is no other way to accomplish a task.

    Bye,
    Jay

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    BINGO. Tools - Options - EDIT....

    Thanx

  9. #9
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-08 12:22, shades wrote:
    CONTROL + ENTER works for me (Excel 97). After entering data, I hit that combination and the cell remains selected.

    ALT + ENTER means inserting a paragraph within the cell.
    Ah, gotcha. I assumed he was just wanting to drop down a line and continue. Sorry!

    _________________
    Kristy

    "There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

    [ This Message was edited by: Von Pookie on 2002-04-09 07:44 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com