In the video I demonstrate how to stay in the same cell after you have pressed the ENTER key to confirm entry.

The key combination to achieve this is CTRL ENTER. ALT ENTER alternatively, creates a new line within a cell.

You can also change the behaviour of the ENTER key in Excel's advanced options. Here you can either disable the "move selection" behaviour completely, or change it to down, left or right.
------------------------