0

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, the cursor 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?

15

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.

8
  • 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".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.