How to Prevent moving to the next Cell after pressing enter in Excel 2010 ?
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 .
Recently Searched terms :
- how to press enter in excel cell
- how to enter in excel
- when return in excel goes to next cell
- excel when hitting enter it will not move to the next cell
- how to stop excel from going down a cell after pressing enter
- how do i stop excell from typing from one cell into the next one
- mac for excel moving cursor to next line in cell
- how to stay in one cell after press enter
- how to stop cell jump excel
- excel press enter move down
- excel 2011 move down within cell
- how to stop access from jumping to the next record after pressing enter key
- how to jump to a cell after i hit enter
- in excel when i press enter changes
- how to write in the cell in mac excel
- how to keep cursor from moving in excel after inputting data
- how to press enter in excel
- how to stop cursor from moving when you type
- how do you push enter in excel cell
- how to stop cell automatically moving down when pressing enter in excel
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
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.