How to Put Multiple Lines in Excel Cell (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

If you use Microsoft Excel, you may have a problem with having more text than fit into a normal cell. To get rid of this issue, you need to put multiple lines in Excel cell. In this article, you will learn 2 easy ways to insert more than one line into a single cell.


Download Practice Workbook

Download the following Excel file for your practice.


2 Easy Ways to Put Multiple Lines in Excel Cell

Let’s first introduce our sample dataset. Here, we pick a data set containing 3 columns. Our mission is to put newlines in a cell so that the text will be easy to view at a glance.

2 Easy Ways to Put Multiple Lines in Excel Cell (Sample dataset)


1. Put Multiple Lines in Excel Cell Using ALT+ENTER Key

In our dataset, we see that we need several line breaks to view our text at a glance. Just follow the steps below to insert more than one line in Excel cell.

Steps:

  • Put your cursor in the text where you want to insert a new line.

Using ALT+ENTER Key

  • Press ALT+ENTER to put a new line to the cell.

Inserting Lines in a Cell Using ALT+ENTER Key

  • Now, you will see a line break. Continue, pressing ALT+ENTER to put more line breaks in your text.

Here is the result,

Insert Line breaks in Excel Cell Using ALT+ENTER Key (Result)

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


Similar Readings


2. Put Multiple Lines in Excel Cell Using the Wrap Text Feature

The Wrap Text button is the most frequently used and easiest method to put automatically new lines in an Excel cell. To wrap the text in your Excel spreadsheet using this button, you need to follow the steps below.

Steps:

  • Select the cells containing the text you need to wrap. We have selected B5:D7 here.
  • Then go to the Home tab >> the Alignment section.
  • Finally, press the Wrap Text button.

Put Multiple Lines in Excel Cell Using the Wrap Text Feature

  • Now to make the text visible within the wrapped cell, apply the hotkeys Alt+H+O+A.

Here is the final output.

Using the Wrap Text Feature (Result)

Read More: VBA to Generate Multiple Lines in Email Body in Excel (2 Methods)


Conclusion

In this brief tutorial, I have discussed 2 easy ways to put multiple lines in an Excel cell. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Hafiz Islam

Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo