● Key combination method

In other text editing software, just press Enter to break lines, but in Excel, the function of Enter key is not to break lines within cells, but to move between cells. What if we sometimes want to break a line? We can press Alt+Enter anytime and anywhere to realize the function of hard carriage return. This method is also applicable to cells that have been entered, and the line breaks at the cursor.

● Format setting method

If you want to display multiple lines of text in the same cell, we can also do this: select the cell to wrap, click the Format menu, select the Cell command, click the Alignment tab, select the word wrap check box in the Text Control section, and finally click OK.

● Content rearrangement method

In another case, we want to wrap lines in the specified area. For example, the text content of A 1 is very long, and we want to display it in columns A to C. We can first select the A 1: C9 area (first select A 1), and then click Edit → Fill → Reorder the content, and the text content of A 1 will be distributed in A1:.