What does shift ENTER do in Microsoft Excel?

Answer 1

The use of the enter key in microsoft Excel is to either:

-Confirm a setting, such as if you typed: "cat", that is what you wanted.

-Input things into an equation (2+2=4)

-Move a cell to the left, right, down, or up.*

*This can be changed in the settings of microsoft excel

Answer 2

The Enter key on the numeric keypad or the Return key on the main keypad are the two main keys. Any of the navigation keys such as the arrow keys or Page Up etc. will also enter a value when it has been typed.

Answer 3

When you are typing something into a cell, it isn't actually stored in it until you hit the enter key. PRessing enter will put what you typed into the cell and then move the active cell to be the next one, so you can type something into another cell.

Answer 4

The rectangular selected area goes 1 UP. Pressing ENTER alone, makes it go 1 DOWN.