How to write multi lines in one Excel cell?

I intend to write multi - lines in one MS Excel cell.

Yet whenever I push the Enter key, the cell editing and enhancing finishes and also the arrow relocates to next cell. Just how can I prevent this?

118
2022-06-25 05:35:30
Source Share
Answers: 3

Use the mix alt+enter

17
2022-06-25 11:55:35
Source

What you intend to do is to cover the message in the existing cell. You can do this by hand by pushing Alt+Enter every single time you desire a new line

Or, you can set this as the default practices by pushing the Wrap Text in the Home tab on the Ribbon. Currently, whenever you strike enter, it will instantly cover the message onto a new line as opposed to a new cell.

136
2022-06-25 11:51:44
Source

You need to make use of Alt+Enter to enter a carriage return inside a cell.

39
2022-06-25 11:51:39
Source