How to change lines in Excel?

Enter a text in Excel typing a carriage return does not implement the same carriage return effect as word, but automatically enters the next cell. Then Excel can not implement a cell in the effect of text return? The answer must be no! from the online summary for later use.

One, the method of automatic line wrapping.

Select the cells that you want to wrap, click the Format menu, select cells, and then select the Alignment tab, and select the Word wrap check box under the text control heading.

Second, manual line-wrapping (Hard return) method.

In the formula bar (or the cell you are editing), click the mouse where you want to wrap the line, and press Alt+enter to wrap.

Both of these methods are simpler, mainly by looking at specific situations to determine which method to use. There are other good ways to welcome the exchange and share.