Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 15 down vote accepted

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.

share|improve this answer
  • 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".

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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