The Same and Different When One Line Break in Excel

Excel 97-2003 currently has very few users, because the installed version is no longer suitable and the toolbars are hidden in, difficult operations, the interface is difficult to adjust. Therefore, Excel 2007-2010 was created to meet many beautiful and smart interface properties, toolbars are displayed right outside the screen, suitable for all manipulation objects.

Similarity : There Are Many Ways to Manipulate Text Breaks in the Same Cell in Excel:

Method 1 : Put the mouse in the cell need to go down / select the right mouse button, select Format Cells / Select Alignment / Select Wrap text.

Check Wrap Text:

Method 2 : Select the mouse in the cell need to down / select the icon on the toolbar / the Word will automatically jump to the line.

Differences :

If in the same box you may need to use a newline, you can choose the above two ways to manipulate right in your lesson, but the above two methods only apply to the words that overflow into the next box. automatically push down other lines.

Case 1 in the same cell, but the letters fit in a cell, do not overflow to the cell next to you select the position to line, press Alt + Enter.

In another case, if you want all the following lines to go down the same line as in case 1, using the Alt + Enter key combination, it will be hard, because we have to do each line and cell one by one. Therefore, if you want the below lines to get down to the line, you should choose according to Method 2, select Wrap text automatically to line or highlight the line / Select right mouse / Select Copy / Select locations to copy / Select Paste.