
To insert a manual line break, execute the following steps.Ģ. On the Home tab, in the Alignment group, click Top Align. Note: by default, Excel aligns text to the bottom (see cell A1).ħ. Enter an extra-long text string in cell B1 and wrap the text in this cell. Simply double click the bottom border of a row header to fix this.ĥ. Note: if you manually set a row height (by clicking on the bottom border of a row header and dragging the separator), Excel does not change the row height when you click the Wrap Text button. Double click the bottom border of the row 1 header to automatically adjust the row height. Click on the right border of the column A header and drag the separator to increase the column width.Ĥ. On the Home tab, in the Alignment group, click Wrap Text.ģ.
