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?
2 Answers
Alt + Enter will create a new line in an Excel field
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.
<enter>). Thank you!