+ Reply to Thread
Results 1 to 3 of 3

Spreadsheet shifts to the left when ENTER key is pressed

  1. #1
    Registered User
    Join Date
    08-23-2011
    Location
    Toronto,Ontario
    MS-Off Ver
    Excel 2003
    Posts
    48

    Spreadsheet shifts to the left when ENTER key is pressed

    When I enter a value into a cell and press "ENTER" or press the Right Arrow the whole spread shifts to the left instead of just confirming the entry of the cell and moving one cell(column) to the right.

    This is a spreadsheet that I have used for over 3 years so something has changed in one of the settings.

    I have Office 2003.

    Danny

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Spreadsheet shifts to the left when ENTER key is pressed

    Tools>>Options>>Edit>>Move Selection After Enter>>Select RIGHT from the drop down>>Press Ok...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Spreadsheet shifts to the left when ENTER key is pressed

    Also, see if scroll-lock is on?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Return alt-enter when enter is pressed in a specific cell
    By bigsteve in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2013, 10:21 AM
  2. [SOLVED] Focus moving down instead of down and left when return is pressed.
    By jimblob21 in forum Excel General
    Replies: 4
    Last Post: 09-19-2012, 10:44 AM
  3. do something when enter is pressed
    By TechRetard in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-11-2011, 05:24 PM
  4. Run a macro when Enter is pressed
    By Speclt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2011, 01:17 AM
  5. Run a macro when 'Enter' is pressed?
    By jcup in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2007, 02:11 PM

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