How to Do a Line Break in Excel (4 Ways)

Line breaks are important to improve visuals in cells. It can also be used to store more than one piece of data if needed in a single cell. Whatever your cause might be, here I will help you with how to do a line break in Excel.


Download Practice Workbook

You can download the workbook with all the sheets and examples used for this demonstration below. Download and give it a try.


4 Ways to Do a Line Break in Excel

There are 4 distinct ways you can do a line break in Excel. There can be sub-methods of the methods. Either way, I will be going through each method. Follow along to learn how each one works or find the suitable one for you from the table of contents above.

For most of the article, I will be using the following dataset to do a line break in between in Excel.

how to do a line break in excel


1. Do a Line Break Using Keyboard Shortcut

You can easily add a line break by using keyboard shortcuts depending on the operating system you are using. For Windows users it is Alt+Enter and for Mac users it is Control+Option+Enter.

For more details, go through these steps.

Steps:

  • First, select cell C5.
  • Then go into edit mode either by double-clicking the cell or pressing F2 on your keyboard.
  • After that, click the exact position where you want to break the line to get the cursor there.

  • Now press Alt+Enter if you are a Windows user or press Control+Option+Enter if you are using Mac. It will do a line break there.

how to do a line break in excel

  • Repeat as many times as you need. You will finally have your desired lines.

Note: You need to manually increase the row height if you want a full view of all the contents in the cell.

Read More: [Fixed!] Line Break in Cell Not Working in Excel


2. Utilizing Wrap Text Command in Excel

You can use the Wrap Text feature to do a line break in an Excel cell. Wrap Text generally helps to avoid the cell content overlapping on the next cell and tries to give a clearer view of what is inside of the cell. If you want to automate a line break using wrap text follow these steps.

Steps:

  • First, select the cells where you want to add your line breaks.

  • Then go to the Home tab from your ribbon and from the Alignment group, select Wrap Text.

how to do a line break in excel

  • Now, write down your text in your cell. It will automatically break the line if the value overflows the cell boundary.

how to do a line break in excel

  • Repeat this for all the cells and you will have cells with line breaks.

how to do a line break in excel

Read More: How to Remove Line Breaks in Excel (5 Ways)


Similar Readings


3. Using ‘Find and Replace’ Command

You can also use the Find and Replace command in Excel to do a line break. With this tool, you can replace a character or a set of characters with other ones. To break lines we can suitably use a particular character to replace it with a line break. Follow these steps for a detailed guide.

Steps:

  • First, copy and paste the value into your desired cell. If you want to replace the original data you can skip this step.

  • After that, select all the cells you want to put line breaks in.
  • Then, press Ctrl+H to open up the Find and Replace tool on your Excel.
  • Put a space inside the Find what field. In the Replace with field, select and press Ctrl+J to insert break here.

how to do a line break in excel

  • After that, click on Replace All. You will have your spaces replaced by line breaks.

how to do a line break in excel

Read More: How to Replace Line Break with Comma in Excel (3 ways)


4. Applying Different Formulas to Do a Line Break

There are formulas and functions you can use to do a line break in Excel. Usually, the CHAR function takes a numerical argument and returns the character which the number represents. CHAR(10) indicates a line break in Excel formulas. You can combine it with other functions like TEXTJOIN or CONCAT functions or just simply with the ampersand (&) sign in the formulas to add line breaks.

For formulas, I modified the dataset slightly for the simplicity of applications and understanding. This is the version I will be using for the rest of the article containing formulas.


4.1 Using Ampersand Sign

You can combine the CHAR function with the ampersand (&) sign in formulas to add a line break after texts. Follow the steps for the formula and application.

Steps:

  • First, select cell E5.
  • Write down the following formula.

=B5&CHAR(10)&C5&CHAR(10)&D5

  • Then press Enter. You will have all the text values added with a line break in between them.

how to do a line break in excel

  • Click and drag the Fill Handle icon to fill out the rest of the cells.

how to do a line break in excel


4.2 Applying CONCAT Function

Similarly, you can add text values with a line break between them with the CONCAT function. This function takes several arguments and concatenates all the values in them.

Follow these steps for more details.

Steps:

  • Select cell E5.
  • Write down the following formula in the cell.

=CONCAT(B5,CHAR(10),C5,CHAR(10),D5)

  • Now press Enter on your keyboard.

how to do a line break in excel

  • Finally click and drag the Fill Handle icon to fill out the rest of the cells.

how to do a line break in excel

🔍 Breakdown of the Formula

👉 CHAR(10) represents the line break. And when used in a formula, returns the line break.

👉 CONCAT(B5,CHAR(10),C5,CHAR(10),D5) concatenates the values in the range of cells B5:D5 with a line break in between them.


4.3 Utilizing TEXTJOIN Function

There is another function called the TEXTJOIN function to join texts with a delimiter in between them. This function takes the delimiter as the first argument, a boolean argument of whether to ignore the empty strings or not and text values as the later arguments. If we add line breaks in place of delimiter, we can easily add line breaks with this function.

Follow these steps below for a more detailed guide.

Steps:

  • First, select cell E5.
  • Write down the following formula.

=TEXTJOIN(CHAR(10),TRUE,B5:D5)

how to do a line break in excel

  • Press Enter to get the value.

  • Finally, click and drag the Fill Handle icon to fill up the rest of the cells.

how to do a line break in excel

🔍 Breakdown of the Formula

👉 CHAR(10) returns a line break in the formula.

👉 The boolean value TRUE indicates it will ignore all the empty cells while joining the values.

👉 Finally, TEXTJOIN(CHAR(10),TRUE,B5:D5) joins the values within the range of cells B5:D5 with a line break after each cell value and ignores all the empty values.


Conclusion

These were all the methods to do a line break in Excel. Hope you found this guide informative and helpful. If you have any questions or suggestions let us know below. For more detailed guides like this, visit Exceldemy.com.


Related Articles

Abrar Niloy

Abrar Niloy

Hi! my name is Abrar-ur-Rahman Niloy. I have completed B.Sc. in Naval Architecture and Marine Engineering. I have found my calling, if you like, in Data Science and Machine Learning and in pursuing so, I have realized the importance of Data Analysis. And Excel is one excel-lent tool do so. I am always trying to learn everyday, and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo