How do I get the newline character to be processed so that lines wrap?

Question

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?

Answer 1

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

Answer 2

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.