How to Add a Line in Excel Cell (5 Easy Methods)

When working with Microsoft Excel, you may find problems with data or text not fitting properly in a cell. In that scenario, you need to wrap text or add a line break in the cell. In this article, I am going to show you how to add a line in an excel cell. Check this link for more information.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


5 Suitable Methods to Add a Line in Excel Cell

In the following, I have described 5 methods to add a line in the excel cell. Suppose we have a dataset containing some book names.

Add a Line in Excel Cell


1. Use Keyboard Shortcut to Add a Line in Excel Cell

Using a keyboard shortcut is the most frequently used method to add a line in an excel cell.

Steps:

  • Select the cell to add a line.
  • Put the cursor in the cell where you want to add a line.

Keyboard Shortcut to Add a Line

  • Now press ALT+Enter.

  • Thus you can add a line.
  • In the following, we have added a line in each cell.

Use Keyboard Shortcut to Add a Line in Excel Cell

Read More: New Line in Cell Formula in Excel (4 Cases)


2. Apply Wrap Text Feature to Add a Line in Excel

Excel has some built-in features to add a line in an Excel cell.

By enabling the wrap text feature you can automatically add a line adjusting the cell.

Steps:

  • Select cells to add a line. Here I have selected cell (B5) to cell (B9).
  • Click the right button of the mouse to enable options.

Wrap Text Feature to Add a Line in Excel

  • From the options choose “Format Cells”.

Apply Wrap Text Feature to Add a Line in Excel

  • A new window “Format Cells” will appear.
  • From the “Alignment” section choose “Wrap Text”.
  • Press OK.

Apply Wrap Text Feature to Add a Line in Excel

  • Here we have our text wrapped in all the selected cells.

To work quickly you can select wrap text from the Home ribbon.

  • Select cells and apply “Wrap text” from the Home ribbon.

Apply Wrap Text Feature to Add a Line in Excel

  • Here we got all our text wrapped by using a single click.

Read More: How to Go to Next Line in Excel Cell (4 Simple Methods)


Similar Readings


3. Add a Line Break After a Specific Character in Excel Cell

Sometimes we may need to add a line break after a specific character. In this method, I am describing the method to do so.

Steps:

  • Choose cells.
  • Press: Ctrl+H.

Add a Line Break After a Specific Character

  • A new window “Find and Replace” will appear.
  • In the “find what” section write “, “.
  • Select the “Replace with” section and press Ctrl+J to insert the line feed.
  • Click “Replace All”.

  • A new window will appear confirming the replacement.
  • Click OK.

  • This way you can add a line in the excel cell after a specific character.

Read More: How to Replace a Character with a Line Break in Excel (3 Easy Methods)


4. Apply TEXTJOIN Function to Add a Line in Excel

With the use of different types of functions, you can add a line in excel. In this method, I am going to apply the TEXTJOIN function to add a line in the excel cell. Suppose we have a dataset containing some book’s names, their writer names, and published years.

Apply TEXTJOIN Function to Add a Line in Excel

Steps:

  • Choose cell (E5).
  • Apply the formula-
=TEXTJOIN(CHAR(10), TRUE, B5:D5)

Where,

  • The TEXTJOIN function combines text from multiple ranges or strings.
  • The CHAR function returns a character when given a valid character code.
  • B5:D5= It is the cell range.

  • Press Enter.
  • You will see all the characters in the cell range are added to the selected cell with a line break.
  • Drag down the “Fill handle”.

  • Thus we got all our cells with line breaks in a single cell.

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


5. Use CONCATENATE Function to Add a Line in Excel Cell

Applying the CONCATENATE function you can also add a line in the excel cell.

Steps:

  • Select a cell. Here I have chosen cell (E5) to add a line.
  • Apply the formula-
=CONCATENATE(B5, CHAR(10), C5, CHAR(10), D5)

Where,

  • The CONCATENATE function joins two or more texts into one single text.
  • The CHAR function returns a character when given a valid character code.

 Use CONCATENATE Function to Add a Line in Excel Cell

  • Click Enter.
  • Drag down the “Fill handle” to get results in every cell.

  • Well, this is the simplest way to add a line in excel.

Read More: How to Add New Line with CONCATENATE Formula in Excel (5 Ways)


Things to Remember

  • When using Mac instead of a PC use Char(13) and replace Char(10).
  • Before applying the formula in the cell make sure to enable “Wrap Text”. Otherwise adding Char(10) would make no changes to the result.

Conclusion

In this article, I have tried to cover all the methods to add a line in excel. Hope you find it useful. If you have any queries regarding this article don’t forget to inform us in the comment section below. Thanks!


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo