How to wrap rows in the same cell in Excel

In Excel, there are two ways to wrap lines within a cell: Hold down Alt and press Enter. To use the text wrapping function CONCATENATE, enter the formula =CONCATENATE(cell to wrap, CHAR(10)).

How to wrap lines in the same cell in Excel

In Excel, wrap lines in a cell Can make the data clearer and easier to read. Here are two methods:

Method 1: Use Alt Enter

1. to place the cursor in the cell you want to wrap.
2. Press and hold the Alt key.
3. Press the Enter key.
4. Release the Alt key to wrap lines within the cell.

Method 2: Use the text wrap function

1. Enter the formula<code>=CONCATENATE(A1, CHAR(10), A2)</code>, where A1 and A2 are the cells you want to join.
2. CHAR(10) represents newline character.
3. Press the Enter key to wrap lines within the cell.

Example:

Suppose you want to display the following information in cell A1:

• Product Name: Laptop
• Price: $1000

You can use the following methods:

• Method 1: Enter in cell A1:

<code>笔记本电脑
Alt + Enter
1000 美元</code>

• Method 2: Enter the following formula in cell A1:

<code>=CONCATENATE(A1, CHAR(10), A2)</code>

Both methods will wrap lines in cell A1 , display the data as follows:

<code>笔记本电脑
1000 美元</code>

The above is the detailed content of How to wrap rows in the same cell in Excel. For more information, please follow other related articles on the PHP Chinese website!