- Release:
- Update:
How to start a new line within a cell
Excel is a spreadsheet software, but you often enter text. Long text should be inserted line breaks, but just pressing enter key make complete entry and move to down.
When we make a line break inside a cell, what should we do? We are introducing how to do it.
Try pressing Enter key
Let's review what happen when you press the Enter key, it doesn't make a break though.
Enter text in a cell
![Enter text](/_wt/officehack201907/img/en/cell-newline1-1.png)
Text is entered in a cell.
![Select where you want to make a break](/_wt/officehack201907/img/en/cell-newline2-1.png)
Move the cursor to where you want to insert a break.
Press Enter key
![Try to press enter key](/_wt/officehack201907/img/en/cell-newline3-1.png)
When Enter key is pressed, a cell below is active.
Make a line break within a cell
This is how to make a line break.
Move the cursor
![Select where you want to insert a line break](/_wt/officehack201907/img/en/cell-newline4-1.png)
Move the cursor to where you want to insert a break.
Expand formula bar
![Expand formula bar](/_wt/officehack201907/img/en/cell-newline5-1.png)
When you make line breaks, you'd better expand the formula bar. Click the ▼ on the right end of formula bar.
![After expanding formula bar](/_wt/officehack201907/img/en/cell-newline6-1.png)
Formula bar is expanded.
Make a line break by using Alt key
![insert a line break inside a cell](/_wt/officehack201907/img/en/cell-newline7-1.png)
Press Enter key and Alt key at the same time.
![After a line break is inserted](/_wt/officehack201907/img/en/cell-newline8-1.png)
Line break is inserted.
![Adjust cell width and height](/_wt/officehack201907/img/en/cell-newline9-1.png)
Change the width and height of the cell.
How to insert a line break with CHAR function
When concatenate cell A1 and cell B1, you can insert a line break with a function.
The ampersand (&) calculation operator
![Concatenate texts](/_wt/officehack201907/img/en/cell-newline10-1.png)
Display concatenated text string in cell C1 with the ampersand (&) concatenation operator. Make sure that Warp Text is active.
![Concatenate with “&”](/_wt/officehack201907/img/en/cell-newline11-1.png)
Combine text in A1 and B1 with the ampersand (&).
![After concatenation with &](/_wt/officehack201907/img/en/cell-newline12-1.png)
Texts are combined in C1, but a line break isn't inserted.
Insert a line break with CHAR function
![line break with CHAR function](/_wt/officehack201907/img/en/cell-newline13-1.png)
We introduce how to insert a line break with CHAR function. Make sure that Warp text is active.
![After entry CHAR function](/_wt/officehack201907/img/en/cell-newline14-1.png)
Add "CHAR(10)" between "&". "(10)" means LF (line feed).
This function made a line break between A1 and B1, so could make a line break.