Rate this post

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.
#PressEnterAndMoveSelection #KeyboardShortcut
————————————————————————————————————-
Support the channel with as low as $5

————————————————————————————————————-
Please subscribe to #excel10tutorial

Playlists:
Advance Excel Tutorial:
Excel Tutorial for Beginners:
Excel Case:
Combine Workbook & Worksheets:
Excel VBA Programming Course:

Social media:
Facebook:
Twitter:
Blogger:
Tumblr:
Instagram:
Hubpages:

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

Nguồn: http://tipthuthuat.cc