vote up 1 vote down star

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

But whenever i press Enter key it's end cell editing and move to next cell.

flag

3 Answers

vote up 5 vote down check

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.

link|flag
Thank you very much :) – Wahid Bitar Nov 22 at 13:48
vote up 2 vote down

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

link|flag
vote up 2 vote down

Use the combination alt+enter

link|flag

Your Answer

Get an OpenID
or
never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.