How do you get to the next line in Excel?

Question

If i have a cell that is multiple lines of text, I can drag the top bar down to see all the different lines in the cell but when I hit enter it goes out of the cell and onto the next.
How do I move up and down the text within a multi-line set of text within one Excel cell?

Answer 1

Just press F2 on the cell. That will put you in edit mode in which it is possible to use the arrow keys. If you want to enter newlines in the cell yourself, you have to do that with alt + enter.

Answer 2

• ALT+Enter and Backspace to edit within the cell

• Keep the alt key pressed and move around with the cursor keys

• F2 or Mouse Click to enter edit mode

• If you get troubled by the Enter moving you to the next cell below,
  From the Menu, Tools ==> Options ==> Edit,
  uncheck "Move selection after enter".