How to write multi lines in one Excel cell?

Become or hire the top 3% of the developers on Toptal https://topt.al/25cXVn

--

Music by Eric Matyas
https://www.soundimage.org
Track title: The Builders

--

Chapters
00:00 Question
00:24 Accepted answer (Score 136)
00:57 Answer 2 (Score 39)
02:03 Answer 3 (Score 39)
02:17 Answer 4 (Score 17)
02:29 Thank you

--

Full question
https://superuser.com/questions/73838/ho...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#microsoftexcel #textediting

#avk47

ACCEPTED ANSWER

Score 139

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.

enter image description here

ANSWER 2

Score 39

You have to use Alt+Enter to enter a carriage return inside a cell.

ANSWER 3

Score 17

Use the combination alt+enter

ANSWER 4

Score 7

Alt + Enter never worked for me. I had to go to Format Cells and make sure that the Number tab was set to Text. That allowed me to see exactly as I had input. My issue could have been Mac specific though.