What happens when you press enter key in excel?
When you press Enter in excel generally you enter the data and the selection moves down one cell. If you want you can change selection moving direction. Though your selection moves down one cell generally still you can configure this in a way that it could move one cell UP, DOWN, LEFT, RIGHT also you can configure it in a way that the selection stays in the same cell.
The easiest way to keep the selection in the same cell after pressing the Enter key is to use a keyboard shortcut key CTRL+ENTER. If you use this keyboard shortcut you will not only enter the value but also keep the selection in the same cell.
Now i will explain how you can press enter and move the selection to Right, Left, Down, Up and also in the same cell using nothing but excel feature.
Lets get started.
Step 1: Click on the file
Step 2: Select “Option”
Step 3: Click on “Advanced”
Step 4: Now at the top of the screen you will find “After pressing enter, move selection” drop-down list.
Step 5: Now if you select up, down, left and right the selection will move up, down, left and right one cell respectively.
Step 6: If you want to keep the selection in the same cell after pressing enter then you’ll have to un-check “After pressing enter, move selection” option.
Done. Now you can use both keyboard shortcut and also excel feature to press enter and keep the selection in the same cell.
Thanks for watching.
Support the channel with as low as $5
Please subscribe to #excel10tutorial
Advance Excel Tutorial:
Excel Tutorial for Beginners:
Combine Workbook & Worksheets:
Excel VBA Programming Course:
Tag: enter in excel, press enter and keep the selection in the same cell, press enter and stay in the same cell, how to stay in the same cell after pressing the enter key in excel, press enter and move to right cell, press enter and move to left cell, press enter and move to down cell, press enter and move selection, press enter and move to upper call, navigation with the enter key, Excel 10 Tutorial, Excel 2010, excel tutorial, excel, keyboard shortcut, e10t, excel tricks, excel tips, How to
Xem thêm: http://tipthuthuat.cc/category/review
Thanks and very informative
Still the text isn't going down if I tap enter
Ctrl+Enter isworking but when i use formula =len shows result is 2
Its alt+enter not cntrl+enter..
am using a barcode scanner to read in barcode numbers into excel. But > everytime after I scan a barcode, excel moves to the cell in the next row. > What I want is moves down to the next column. > Anyone with information please help.
Excellent explanation, thank you.
Still not solved when press enter and i try to write again, it will overwrite the previous word and will be deleted any one have solution please i want after press enter to move to another line in the same cell
I hate excel and all microsoft for its complicated command