multi line entry
Create multi line entries in a Microsoft Excel cell by pressing the Alt and Return keys. This inserts a line break at that point in the text.
Great for controlling how the text in cells will appear. For example, for inserting addresses into spreadsheets as it avoids having addresses in multiple cells and makes mail merging addressing dead easy.
This is different from word wrap which scrolls text on the next line depending on the size of the cell. By using Alt + Rtn you determine where the line break comes.
Hubs of multi line entry…
hubs about Multi-Line to Create multi line entries in a Microsoft Excel cell by pressing the Alt and Return keys. This inserts a line break at that point in the text. Great for controlling how the text in cells will appear. For example, for inserting a…