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?
Excel – How to write multi lines in one Excel cell
microsoft exceltext editing
microsoft exceltext editing
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?
Best Answer
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.