Insert New Line in Excel Cell
All the regular users of excel spreadsheet generally work with numbers, but dealing with non-numerical data becomes complex in many situations. One such situation is when we are typing the data often times we need to enter some data to the next line or next paragraph. But when we type the data in the cell if we press enter key it will jump to next cell, if use arrow keys, this will also jump to respective cells based on which side of the arrow key we press. So, how do we insert a new line in excel cell or line breaker in a single cell itself?
In this article, we will show you ways of inserting new line in excel cell.
How to Insert New Line of Text in Excel Cell?
Inserting a new line or line breaker or starting the new line in the same cell is not the regular scenario we all face but the very useful technique to know to deal with rare scenarios.
We can insert a new line in excel cell using multiple ways, we will show each one of them here in this article.
Method #1 – Insert New Line By Manually or Shortcut Key
For an example look at the below data of name and address.
We have three city names. We need to show each city name in a new line like the below.
So, to insert new line place a cursor from where we need to insert a new line in excel cell. In this after the word “Bangalore” we need to insert a new line in excel cell, so I will place a cursor before the letter “M”.
Now hit “ALT + ENTER” key to insert new line in the same cell.
As we can see in the above image word “Mysore” and “Mumbai” has shifted to the next line. Now place a cursor after the word “Mysore” and press “ALT + ENTER” key.
Now simply hit only ENTER key to have each city name in new lines.
Method #2 – Insert a New Line in Excel Cell by Using Char Function
For an example look at the below data of address.
Now from these various pieces of the address, we need to create a combined address. For this, we need to insert new line breaker or new line between Name and Address.
Now insert a new column for Full Address.
First, combine “First Name” & “Last Name”.
After combining the first name and last name, we need to insert a new line in excel cell, so that address content comes in the next line. For this open CHAR function.
For CHAR function we need to supply a number which can insert a new line in excel cell. So, number 10 will insert a new line to the cell.
Now combine remaining address contents using ampersand symbol.
Even after applying the CHAR(10) function we can still see the address in single line only. One of the things we need to do after inserting the line breaker through CHAR(10) function is we need to wrap the cell.
Now drag down the formula to remaining cells to have a full address like the above.
Note: If you are using MAC system then you need to insert CHAR(13) function instead of CHAR(10) function.
Method #3 – Create Name Manager With CHAR(10) Function to Insert New Line
As we can see in the above example we can insert a new line in excel cell by using CHAR(10) function. But if you are not a big fan of inserting CHAR(10) function all the time, you can create a name manager to use it with simple words.
Go to FORMULA Tab and click on “Define Name”.
Now give a name to the “Name Manager” and insert the formula as CHAR(10).
Click on Ok. Now instead of inserting the function CHAR(10), we can use the word “NL” (New Line) to insert a new line.
Things to Remember Here
- We can also push the content to the new line by putting extra spaces but not a recommended technique. Don’t try this.
- ALT + ENTER technique works well for a smaller amount of data.
- CHAR(10) inserts a new line to the cell.
- We can create a name manager with CHAR(10) function to supply name instead of formula while inserting a new line.
This has been a guide to New Line in Excel Cell. Here we learn how to insert a new line in excel cell by using the shortcut key, CHAR function and create name manager with CHAR(10) and downloadable excel template. You may learn more about excel from the following articles –