microsoft excel
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?
What you want to do is to wrap the text in the current cell. You can do this manually by pressing Alt + Enter every time you want a new line
Or, you can set this as the default behaviour by pressing the Wrap Text in the Home tab on the Ribbon. Now, whenever you hit enter, it will automatically wrap the text onto a new line rather than a new cell.
How your text gets copied in to Word depends on the formatting option chosen. In Word 2010, the default format option is HTML Format. There are four main options for how to copy text into Word. (Formatted Text (RTF), Unformatted Text, HTML Format, & Unformatted Unicode Text)
Pasting in with formatted text creates mini tables in Word. (The blue outlines.)
To get unformatted text in Word without the double quotes:
Alt + E, S)This also works to paste the results without quotes into another editor. Simply alter step 3 to paste into the other editor.
It would probably be faster however, to simply paste as normal and then use Replace to find and remove all double quotes.
Best Answer
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.