How to Prevent moving to the next Cell after pressing enter in Excel 2010 ?

Published on May 27, 2011 by

Filed under Excel, MS Office, Tools

Last modified May 27, 2011

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 700 times

When you type a value in a cell and press enter , you might see that you would have moved to the next cell by default .

To prevent this in Excel 2010 ,

1. Go to File – > Options

2. In the advanced tab of the Excel Options , disable / uncheck the “After pressing Enter , move selection ” in the Edition Options and click ok .

Now type in the values inside the call and press enter , you should see that the cursor to edit stays on the same cell .

 

Tags :

2 Comments

  1. Hi! I didn`t know that we can do that! maybe you would like to read this:
    http://runakay.blogspot.com/2011/07/moving-cells-in-excel-without-copying.html

    July 26, 2011 - 12:57 am

  2. steve bales

    There is a glitch in this. If you protect the sheet, and un-check “select locked cells” and check “select unlocked cells”, it will always move to another cell no matter what you do on the advance option area.

    Very annoying. I don’t want to be able to select protected cells, but I don’t want the enter key to move to another cell.

    December 21, 2011 - 5:23 pm

Leave a Comment