I want to write multi-lines in one MS Excel cell.
But whenever I press the
Enter key, the cell editing ends and the cursor moves to next cell. How can I avoid this?
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.
You have to use Alt+Enter to enter a carriage return inside a cell.
Windows: Alt + Enter
Mac: Ctrl + Option + Enter
Note that inserting carriage returns with the key combinations above produces different behavior than turning on
Wrap Text. In the screenshot below,
column A has the carriage returns and
column B has
Wrap Text turned on. Changing the width of a column with carriage returns doesn't remove them. Changing the width of a column with
Wrap Text turned on will change where the lines break.
Use the combination alt+enter
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.
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?