How does one insert a newline character into a cell of an Excel spreadsheet? [duplicate]

How does one insert a newline character into a cell of an Excel spreadsheet? [duplicate] How does one insert a newline character into a cell of an Excel spreadsheet?
Asked by: Guest \| Views: 361

Total answers/comments: 2

Comments display order:

bert [Entry]

It's Alt+Enter

bert [Entry]

An alternative when you need to make a global change of say "." to a newline open the Find and Replace dialog enter "." in the "Find what" box and in "Replace with" press Alt+0010 and click "Replace All"