3

I have set column to wrap text but if I press Enter to create a new line I don't get a new line inside the cell. It's like it does not treat the newline at all.

What else do I need to set to make this work?

1
  • @Diogo Please check your edits -- many posts need more than just a "?" appended in their title (e.g. this one had broken formatting for <enter>). Thank you!
    – slhck
    Aug 22, 2011 at 18:36

2 Answers 2

6

Alt + Enter will create a new line in an Excel field

5

The trick is to use Alt+Enter to create a new line. Also, when you do that, Excel automatically enables text wrap for the cell.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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