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 an 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 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 the 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.
Now, simply hit only the ENTER key to have each city name in new lines.
#2 Start a New Line in Excel Cell by Using Char Function
We have many built-in excel functionsExcel FunctionsExcel functions help the users to save time and maintain extensive worksheets. There are 100+ excel functions categorized as financial, logical, text, date and time, Lookup & Reference, Math, Statistical and Information functions. similarly to start a new line or any special characters we have a function too, i.e., CHAR function in excelCHAR Function In ExcelThe character function in Excel, also known as the char function, identifies the character based on the number or integer accepted by the computer language. For example, the number for character "A" is 65, so if we use =char(65), we get A..
For 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 the CHAR function, we need to supply a number that can insert a new line in an excel cell. So, number 10 will insert a new line to the cell.
Now combine the remaining address contents using the ampersand symbol.
Even after applying the CHAR(10) function, we can still see the address in a single line only. One of the things we need to do after inserting the line breaker through the CHAR(10) function is we need to wrap the cell.
Now drag down the formula to the 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 the 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 the cell by using CHAR(10) function. But if you are not a big fan of inserting the 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 managerName ManagerThe name manager in Excel is used to create, edit, and delete named ranges. For example, we sometimes use names instead of giving cell references. By using the name manager, we can create a new reference, edit it, or delete it. 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 a name manager with CHAR(10) and a downloadable template. You may learn more about excel from the following articles –