Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: When I press the 'Enter' key I want to go right, not down...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello all,

    Is is possible to change the 'direction' the focus goes when the Enter key is pressed?
    Instead of going down a row in the same column, I would like to go over a column in the same row (as if I pressed the Tab button).
    Ultimately, I would like to be able to press Enter and move over, press Enter and move down. (Start at A1, enter moves focus to B1, enter moves focus to A2, enter moves focus to B2, etc.)
    Thoughts?

    Thanks in advance for your time.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go to tools/options/edit and theres a box that gives you the chioce of which way the cursor moves when you press enter.

    Hope this helps- Todd

  3. #3
    New Member
    Join Date
    Feb 2003
    Location
    Sacramento
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    is there a way to make this workbook specfic?

  4. #4
    Board Regular
    Join Date
    May 2002
    Posts
    890
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by 19-2000
    is there a way to make this workbook specfic?
    You could record a macro

  5. #5
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There are two options I can see:

    Option 1:
    As maxflia suggests, record a macro to change the direction, and include in it the selection of the range (if constant) that you want to enter to. That way, the Enter will move it from A1 to B1 to A2 to B2, etc., until it gets to the end of the selected range.
    Don't forget to do a before-closing macro to re-set the direction.

    Option 2:
    Lay your monitor down on it's left side.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


Some videos you may like

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
  •