Excel: Force a line break in a text cellSeptember 5, 2011
Need to force a line break in an Excel cell?
Just press Alt+Enter where you want the line break to go.
This also works for Excel data used in Word mail merge fields — you can force the text in the mail merge to go onto another line by adding the line break in the Excel cell containing the data. Very handy for a multi line address when you only have, say, two or three cells for the address fields but need four or five lines for some addresses.