What Is the Keyboard Shortcut to Manually Add Line Break in Excel?

  • Double-click on the cell >> place the cursor in the required position >> press the Alt + Enter keys simultaneously to enter a new line.

Applying keyboard shortcut for adding line break

  • Manually repeat this process for the remaining cells.
  • Double-click on the row bar of a cell to adjust the row height and view all the lines.

Double-clicking on the row bars to adjust row height


How to Apply Wrap Text Feature to Add New Line in Excel?

The Wrap Text feature adds new lines with a single click. Learn the steps to learn how to do that.

  • Select the range C5:C10 >> click on the Wrap Text feature.

Applying Wrap Text feature to insert line break

  • Double-click on the row bar of the cells to adjust the row heights.

Since new lines are added based on the existing column widths, we may not always get our required format while applying the Wrap Text feature.

Adjusting row heights


How to Add Line Break in Excel with Formula?

How to Combine Ampersand (&) Operator and CHAR Function to Add New Line While Joining Cells?

Follow the steps below to add line breaks using the Ampersand operator and CHAR function while joining different cells.

  • Insert the following formula in cell E5 >> press the Enter key >> drag down the Fill Handle icon >> double-click on the row bars to adjust row heights.
=B5&CHAR(10)&C5&CHAR(10)&D5

 Using Ampersand Operator and CHAR Function

The Ampersand (&) operator is used for concatenating the cell contents and the CHAR function is used for inserting a line break.

How to Apply CONCATENATE and CHAR Functions for Line Breaks While Combining Cells?

  • In cell E5, type in the following formula >> press the Enter key >> use the Fill Handle tool >> double-click on the row bars to adjust the row heights.
=CONCATENATE(B5,CHAR(10),C5,CHAR(10),D5)

Applying CONCATENATE and CHAR Functions for line break when adding cells

The CONCATENATE function is used for joining the cell contents, and the statement CHAR(10) is used for inserting a line break.

How to Combine TEXTJOIN and CHAR Functions to Add New Line While Joining Cells?

You can combine TEXTJOIN and CHAR functions for line breaks during concatenating multiple cells.

  • Insert the formula below into cell E5 >> press the Enter key >> drag the Fill Handle icon down >> double click on the row bars to view all lines.
=TEXTJOIN(CHAR(10),TRUE,B5:D5)

Using TEXTJOIN and CHAR Functions

Here, the TEXTJOIN function concatenates the cell contents with a line break delimiter expressed by the statement CHAR(10).

How to Insert Line Break After a Specific Character in Excel?

Insert line breaks after any specific character by using the Find and Replace feature.

  • Select the range C5:C10 >> click on the Find & Select dropdown menu from the Home tab >> select the Replace option.

Also use the keyboard shortcut Ctrl + H as an alternative.

Selecting Find and Select feature

  • In the Find what textbox, type “, ” and in Replace with textbox, press the Ctrl + J keys simultaneously.
  • Click on the Replace All button.

Replacing a character with line break in Excel

  • Double-click on the row bar of cells to adjust row heights and view all lines.

Double-clicking on the row bars to view line break in Excel


How to Remove Line Breaks in Excel?

When we don’t need line breaks; we can remove them.

  • Select the range C5:C10 >> click on the Find & Select dropdown menu from the Home tab >> select the Replace option.

Use the keyboard shortcut Ctrl + H as an alternative.

Using Find and Replace Feature

  • A user form like the following will appear. In the Find what textbox, press the Ctrl + J keys simultaneously, and in Replace with textbox, type “, ”.
  • Click on the Replace All button.

Removing line break in Excel using Find and Replace feature

  • Select the range C5:C10 again and deselect the Wrap Text feature to view the required result.

Deselecting Wrap Text feature


What Are the Things to Remember?

  • You must adjust the row height by double-clicking on the row bars to view all the contents in a cell after adding line breaks in Excel.
  • For directly inserting a line break in a cell, we need to use the keyboard shortcut Alt + Enter.
  • For inserting line breaks to a range of cells, we can use the keyboard shortcut Ctrl + J in the Find and Replace feature.

Frequently Asked Questions

1. What is the keyboard shortcut for adding line breaks on the Macintosh Operating System (Mac OS)?

Answer: The keyboard shortcut for line breaks in Excel for the Macintosh Operating system is Control + Option + Return.

2. Can I add line breaks in a formula in Excel?

Answer: Yes, we can add line breaks in a formula in Excel. For this purpose, use the keys Alt + Enter where needed.

3. Can I apply line breaks to multiple cells or a range of cells simultaneously in Excel?

Answer: Yes, we can apply line breaks to multiple cells or a range of cells simultaneously by using the Find and Replace feature in Excel. For that, select the range of cells, open the Find and Replace user form, and replace the desired character with a line break.


Line Break in Excel: Knowledge Hub


Download Practice Workbook


<< Go Back to Text Formatting | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Seemanto Saha
Seemanto Saha

Seemanto Saha graduated in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. He has been with ExcelDemy for a year, where he wrote 40+ articles and reviewed 50+ articles. He has also worked on the ExcelDemy Forum and solved 50+ user problems. Currently, he is working as a team leader for ExcelDemy. His role is to guide his team to write reader-friendly content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo