To add space between lines of text in a cell, double-click the cell, click where you want to break the line, and then press ALT+ENTER as many times Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac.
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.
Table of contents
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
Text is entered in a cell.
![Excel Excel](https://excelchamps.com/blog/wp-content/uploads/2018/07/concatenate-with-line-break-using-concatenate-function.png)
Move the cursor to where you want to insert a break.
Press Enter key
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
Move the cursor to where you want to insert a break.
Expand formula bar
When you make line breaks, you’d better expand the formula bar. Click the ▼ on the right end of formula bar.
Formula bar is expanded.
Make a line break by using Alt key
Press Enter key and Alt key at the same time.
Line break is inserted.
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
Display concatenated text string in cell C1 with the ampersand (&) concatenation operator. Make sure that Warp Text is active.
Combine text in A1 and B1 with the ampersand (&).
Texts are combined in C1, but a line break isn’t inserted.
Insert a line break with CHAR function
We introduce how to insert a line break with CHAR function. Make sure that Warp text is active.
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.
OS : Windows 10, Software : Excel 2016
![Excel For Mac Line Break In Cell Excel For Mac Line Break In Cell](http://contexturesblog.com/wp-content/uploads/2011/08/linebreak07.png)
Featured Products
I have a double problem :
The final result is that after merging an Excel file ('database') with
a Word file, putting some of the Excel data into cells in a Word table,
some of the cells' contents are partially misaligned. I format a Word
cell to contain only one data item ('parcel_address'), normally
left-aligned, and in some cases, the inserted data from Excel is split
into 2 paragraphs, the first being left aligned with a 7,62cm
left-margin, the second part being OK (no left margin).
Why is this ?
Well, in Excel, the 'parcel_address' is a concatenated string with
company, street, zip code, city and country all put together. The
glitch is with the street name, which itself comes from an internet
hosted application : I export the data (ISO Latin 1 character encoding)
and have to convert it to Mac Roman + Mac line breaks with TextWrangler
before before being able to read it correctly into Mac Excel 2004.
The result, at the end, is that the original line break in a multi-line
street name turns into a paragraph mark in Word, which misaligns the
first part of the address.
Why ?
How can I work around this problem ?
Thanks for any help,
Rup
The final result is that after merging an Excel file ('database') with
a Word file, putting some of the Excel data into cells in a Word table,
some of the cells' contents are partially misaligned. I format a Word
cell to contain only one data item ('parcel_address'), normally
left-aligned, and in some cases, the inserted data from Excel is split
into 2 paragraphs, the first being left aligned with a 7,62cm
left-margin, the second part being OK (no left margin).
Why is this ?
Well, in Excel, the 'parcel_address' is a concatenated string with
company, street, zip code, city and country all put together. The
glitch is with the street name, which itself comes from an internet
hosted application : I export the data (ISO Latin 1 character encoding)
and have to convert it to Mac Roman + Mac line breaks with TextWrangler
before before being able to read it correctly into Mac Excel 2004.
The result, at the end, is that the original line break in a multi-line
street name turns into a paragraph mark in Word, which misaligns the
first part of the address.
Why ?
How can I work around this problem ?
Thanks for any help,
Rup