+ Reply to Thread
Results 1 to 4 of 4

Pressing enter and selected cell changes randomly

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2007
    Posts
    12

    Pressing enter and selected cell changes randomly

    Hi,

    I like that when I press 'Enter' the selected cell moves downwards. However, at times it randomly decides to change the direction it moves in. It has been known to move left, right or up when I press 'Enter' rather than down, even changing direction when part way through using/building a spreadsheet. I know how to change this back so it moves downwards but it still, randomly, changes direction.

    Does anyone know how to stop this as it's very annoying!

    Many thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Pressing enter and selected cell changes randomly

    Hey Big_Kev,

    1. Do you have any VBA behind your worksheet? (Is someone playing with you - troll?)
    2. In Options - Advanced - Editing Options - After Pressing Enter, move selection .. Is how you change this direction default.
    3. Is your worksheet protected so the "next" cell might not be available and this is causing your confusion?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    10-08-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Pressing enter and selected cell changes randomly

    Thanks for the suggestions MarvinP.

    1. No, this can occur on a blank workbook
    2. Indeed, that I knew and have to change every time this issue occurs
    3. No, occurs on unprotected sheets

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Pressing enter and selected cell changes randomly

    OK then,

    Do you have the ability to program your keyboard to macros? This is my best guess.

    Do you have any Keyboard software that might be playing with your keystrokes? Look at Task Manager to see what else is running.

    I'm expecting you are using Windows PC and not a Mac?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-16-2014, 04:04 PM
  2. instead of editing cell and pressing enter to change format
    By benjamind11 in forum Excel General
    Replies: 1
    Last Post: 01-23-2013, 11:01 AM
  3. Reselect cell after pressing enter
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2010, 10:38 PM
  4. Alt + Enter when pressing enter in cell?
    By Stiff in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-20-2009, 05:31 AM
  5. Auto Jumping to next cell without pressing enter
    By Steve Brown in forum Excel General
    Replies: 1
    Last Post: 01-21-2008, 02:47 PM
  6. Active Cell after pressing the Enter Key
    By RealNewbie in forum Excel General
    Replies: 2
    Last Post: 10-17-2007, 09:56 PM
  7. Replies: 1
    Last Post: 05-31-2006, 12:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1