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 .