The tutorial will teach you three quick and easy ways to add a line break in Excel cell: use a shortcut to type multiple lines, Find & Replace feature to add a carriage return after a specific character, and a formula to combine text pieces from several cells each starting in a new line.
When using Excel for storing and manipulating text entries, you may sometimes want a certain part of a text string to start in a new line. A good example of multi-line text could be mailing labels or some personal details entered in one cell.
In most Office applications, starting a new paragraph is not a problem - you simply press Enter on your keyboard. In Microsoft Excel, however, this work differently - pressing the Enter key completes the entry and moves the cursor to the next cell. So, how do you create a new line in Excel? There are three swift ways to do this.
The fastest way to create a new line within a cell is by using a keyboard shortcut:
In Excel 365 for Mac, you can also use Option + Return. Option is the equivalent of the Alt key on Windows, so it seems the original Windows shortcut (Alt + Enter) now works for Mac too. If it does not work for you, then try the traditional Mac shortcuts above.
If you are accessing Excel for Mac via Citrix, you can make a new line with the Command + Option + Return key combination. (Thank you Amanda for this tip!)
To add a new line in Excel cell with a shortcut, please follow these steps:
As the result, you will get multiple lines in Excel cell. If the text still shows up in one line, make sure the Wrap text feature is turned on.
The following tips show how to avoid common problems when inserting multiple lines in one cell and demonstrate a couple of unobvious uses.
To see multiple lines in a cell, you need to have Wrap text enabled for that cell. For this, simply select the cell(s) and click the Wrap Text button on the Home tab, in the Alignment group. In some cases, you may also need to adjust cell width manually.
If you'd like to have a gap of two or more lines between different text parts, press Alt + Enter twice or more times. This will insert consecutive line feeds within a cell like shown in the screenshot below:
Sometimes, it may be helpful to show lengthy formulas in multiple lines to make them easier to understand and debug. The Excel line break shortcut can do this too. In a cell or in the formula bar, place the cursor before the argument that you want to move to a new line and press Ctrl + Alt. After that, press Enter to complete the formula and exit the edit mode.
In case you received a worksheet with many one-line entries, breaking each line manually might take hours. Luckily, there is an extremely useful trick to put multiple lines into all selected cells in one go!
As an example, let's add a carriage return after each comma in a text string:
Done! Multiple lines are created in the selected cells. Depending on your input in the Replace with field, you will get one of the following results.
All commas are replaced with carriage returns:
A line break is inserted after each comma, keeping all the commas:
The keyboard shortcut is useful for manually entering new lines in individual cells, and the Find and Replace is great for breaking multiple lines at a time. In case you are combining data from several cells and want each part to start in a new line, the best way to add a carriage return is by using a formula.
In Microsoft Excel, there is a special function to insert different characters in cells - the CHAR function. On Windows, the character code for the line break is 10, so we'll be using CHAR(10).
To put together the values from multiple cells, you can use either the CONCATENATE function or the concatenation operator (&). And the CHAR function will help you insert line breaks in between.
The generic formulas are as follows:
Or
Assuming the pieces of text appear in A2, B2 and C2, one of the following formulas will combine them in one cell:
=A2&CHAR(10)&B2&CHAR(10)&C2
=CONCATENATE(A2, CHAR(10), B2, CHAR(10), C2)
In Excel for Office 365, Excel 2019 and Excel 2019 for Mac, you can also use the TEXTJOIN function. Unlike the above formulas, the syntax of TEXTJOIN allows you to include a delimiter for separating text values, which makes the formula more compact and easier to build.
Here's a generic version:
For our sample data set, the formula goes as follows:
=TEXTJOIN(CHAR(10), TRUE, A2:C2)
Where:
The result is exactly the same as with CONCATENATE:
That's how to add a carriage return in Excel. I thank you for reading and hope to see you on our blog next week!
Formulas to enter new line in Excel cell
20 responses to "How to start a new line in Excel cell: 3 ways to insert a line break"
Hi, the instructions for carriage break in a excel cell do not seem to work for me. I am using Office 365 but via Citrix on a Mac. There is no Alt key, but neither [cntl+cmnd+rtn] nor [cntl+optn+rtn] seem to work. The cell already has an existing Carriage return, ie two lines of text (so yes Warp Text is definitely already enabled for the cell) and I need to add a third line.
yOU MAY NEED TO MAKE YOUR COLUNM WIDER ABSD TURN TEXT WRAPPING ON AS WELL
I think I've found it after trying all combinations. I am also using Office 365 via Citrix on a Max but I do have a function key and an alt key.
I've found 'fn' + 'alt + 'cmd' works for me!
Thank you! This worked for me and is going to save me a ton of time on a project!
I'm on a Mac using excel online. I am trying to do a line return in a cell, i.e., make a new line in the same cell. There is no ALT key.
cntl+cmnd+rtn] nor [cntl+optn+rtn] do not work. I tried it once and it worked. And now it doesn't work anymore. I've tried it 20 times.
What do I do?
Hi Natalie,
The equivalent of Alt on a Mac is the Option key, though in many cases they behave differently. For more information, please see How to use the Alt key on a Mac keyboard.
So, if you are using Mac Excel 365, please try Option + Enter to make a new line in a cell.
also unable to use the key combinations to do a carriage return in an excel cell using a Mac. Any ideas?
For a mac, adopt the same process for formula but use CHAR(13).
I am trying to do a line return on a excel sheet using a mac in the same cell. I have tried cntl + Cmnd + rtn and cntl + opt+ rtn I have tried numerous times on several different excel sheets. Also tried FN + opt+ rtn. Opt+ rtn. I have no alt key on the Mac.
I would like to trim multiple lines within a cell can you anyone give any solution or suggestion on my question?
Hello!
I’m sorry but your task is not entirely clear to me.
Please describe your problem in more detail. Include an example of the source data and the result you want to get. It’ll help me understand your request better and find a solution for you. Thank you.
we all have the same problem, we can't get rid of returns in a cell on a Mac. None of the PC options work. We are typically copying something from a website and it througs a return in the cell. when will someone here answer the bloody question??????
I was having this issue and finally got it to work by pressing [option + return] only. The option key is considered the alt key on a Mac
I'm also accessing Excel via Citrix and this has been driving me SO crazy, but I just figured it out! Command+Option+Return worked! Not sure why the order changed from before.
Amanda, you rock! Thanks :)
you can try using Command + Shift + Enter to break a new line in Mac. Hope it helps you out.
How can I press enter and then go to the next row. For example if I am typing in a row and now I am done and I am at cell G1 and now I want to go to A2. If I hit enter it goes to G2. This might sound stupid but we are trying to format a spreadsheet to go to the next line when you hit enter not tab. And we want to be able to hit enter for each cell in the row rather than tab. Is that possible? Thank you.
Hello!
This is only possible with a VBA macro
Thank you for including the shortcut for Citrix use, big help.
Thank you, thank you. This was a life saver!
Mac and MS office really need to kiss and make up....