How to Start a 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 a very useful technique to know to deal with rare scenarios. Here we will learn how to insert or start a new line in excel cell using the 3 different methods
- Method #1 – Insert New Line Manually or By Shortcut Key
- Method #2 – Using CHAR Excel Function
- Method #3 – Using Name Manager With CHAR(10) Function
#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 start a 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 start a new line, so I will place a cursor before the letter “M”.
Now hit the “ALT + ENTER” key to start a new line in the same cell.
As we can see in the above image word “Mysore” and “Mumbai” have shifted to the next line. Now place a cursor after the word “Mysore” and press the “ALT + ENTER” key.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
Now simply hit only ENTER key to have each city name in new lines.
#2 Start 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 start a 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 start 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 the MAC system then you need to insert the CHAR(13) function instead of CHAR(10) function.
#3 Create Name Manager With CHAR(10) Function to Start a New Line
As we can see in the above example we can insert a new line in 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 insert New Line in Excel Cell. Here we learn how to start a new line in excel cell by using the shortcut key, CHAR function and by creating name manager with CHAR(10) and downloadable template. You may learn more about excel from the following articles –