Results:You have a single cell that contains two lines of text. The cell will work as a heading in pivot tables, subtotals, sorting, and so on.
Additional Details: Using Alt+Enter automatically turns on the Wrap Text option for the cell. You could also turn on the Wrap Text option by choosing Home, Wrap Text icon.
Figure 586 Wrap Text finally has an icon starting in Excel 2007.
Turning on Wrap Text in this manner will probably work for a brief heading like “Prior Year." However, if you want to have control over a long heading, such as “Prior Year Results (Adjusted for Spin-off of the Widget Division)," then it is better to use Alt+Enter to specify exactly where the line break should occur. Wrap text uses a somewhat haphazard splitting of words.
Figure 587 Excel decides where to break lines.
As you make this column wider, Excel changes the way the words are wrapped. It is frustrating to keep adjusting the column widths until you get the words to wrap correctly.
Figure 588 Adjusting column widths to change line breaks rarely works.
Gotcha: After resizing a cell with Wrap Text, you often end up with a row height that is too tall. To correct this, you select the cell and then choose Home, Format dropdown, Autofit Row Height.
Using Alt+Enter gives you absolute control over where the heading breaks. To create the figure below, type Prior Year Results <Alt+Enter> (Adjusted for the <Alt+Enter> Spin-off of the <Alt+Enter> Widget Division). You can make the column wider and center it for the perfect-looking cell.
Figure 589 Press Alt+Enter to wrap the text at logical points.