You can start a new line in the same cell in Excel by using:
- A keyboard shortcut to manually force a line break.
- A formula to automatically enter a line break and force part of the text to start a new line in the same cell.
Start a New Line in Excel Cell – Keyboard Shortcut
To start a new line in Excel cell, you can use the following keyboard shortcut:
- For Windows – ALT + Enter.
- For Mac – Control + Option + Enter.
Here are the steps to start a new line in Excel Cell using the shortcut ALT + ENTER:
- Double click on the cell where you want to insert the line break (or press F2 key to get into the edit mode).
- Place the cursor where you want to insert the line break.
- Hold the ALT key and press Enter.
See Also: 200+ Excel Keyboard Shortcuts.
Start a New Line in Excel Cell Using Formula
In real life, there are many situations when you need to combine text from different cells. Suppose we have a dataset as shown below:
if you want to combine text from different cells to create the complete address, you can use the ampersand (&) operator or the CONCATENATE function.
For example, if I combine using the text in these cells using an ampersand (&), I would get something as shown below:
While this combines the text, this is not really the format that I want. You can try using the text wrap, but that wouldn’t work either.
If I am creating a mailing address out of this, I need the text from each cell to be in a new line in the same cell.
To insert a line break in this formula result, we need to use CHAR(10) along with the above formula.
CHAR(10) is a line feed in Windows, which means that it forces anything after it to go to a new line.
So to do this, use the below formula:
This formula would enter a line break in the formula result and you would see something as shown below:
IMPORTANT: For this to work, you need to wrap text in excel cells. To wrap text, go to Home –> Alignment –> Wrap Text. It is a toggle button.
Tip: If you are using MAC, use CHAR(13) instead of CHAR(10).
Related Excel Tutorial:
- Insert Picture in an Excel Cell.
- CONCATENATE Excel Range with and without a separator.
- MS Help – Start a New Line.