+ Reply to Thread
Results 1 to 5 of 5

Staying in same cell

  1. #1
    Registered User
    Join Date
    02-27-2011
    Location
    Nottingham England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Staying in same cell

    Hi, how do I stop moving to the next cell when I put in a figure and press enter. I want to stay in the same cell until I decide its time to move on.TIA
    Last edited by derekfarr; 02-28-2011 at 09:23 AM.

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Staying in same cell

    Don't press enter!

    Click the tick in the formula bar instead that will allow you to see results of formulae, updating etc
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Registered User
    Join Date
    02-27-2011
    Location
    Nottingham England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Staying in same cell

    what I want to do is put a fig in a cell A and press enter. That fig will now be used to compute a fig in cell B. If the fig in cell B does not tally with a fig in cell C I then what to put a new fig in cell A. This will be an irretative process until I get the correct fig in cell B and I want to put new numbers in cell A as fast as I can hence I don't want to move away from cell A each time I enter a new number. Hope that makes sense

  4. #4
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Staying in same cell

    hold ctrl when pressing enter
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  5. #5
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Staying in same cell

    There's also a setting in > Options, Advanced, Editing options and there's a check box, the default is set to move down after enter. The other options are to move left, right or up. If you uncheck the default option, so that the options are now greyed out then go back to your sheet, when you press enter you'll stay in the same cell.

    only downside to this as opposed to using ctrl + enter is that you are changing the Excel setting as opposed to your sheet setting, so you'll need to change it back each time you use it or all your sheets will have the same actions on enter, ie not moving to the next cell

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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