4 Ways to Make Two Lines in One Cell in Excel

Whenever we have to put long texts in Excel cells, the cell size usually doesn’t adjust to the text size automatically. Hence comes the necessity to customize the cells according to our own needs. Not only can we increase or decrease the cell size, but we can also put line breaks to make two or multiple lines in one cell to make the whole content visible. In this article, we will demonstrate how you can make two or multiple lines in one cell in Excel.


📁  Download Excel File

Download this to practice with us.


Learn to Make Two Lines in One Cell in Excel with These 4 Quick Methods

To make two lines in one cell in Excel, today we will use a list of books whose names don’t fit in the regular cells.  So we will use line breaks to adjust the text size within the cells. There will be 4 tricks we will be showing you. These are very simple and fun to become pro at. So stay with us to know all of them at once.

Dataset to make two lines in one cell

Method 1

1. Applying Keyboard-Shortcut

In Excel, we can create two lines by adding a line break. Let’s work in the Excel workbook to see how.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select the cell where you want to put a line break. We are selecting cell B6.
  • Then, go to the Formula bar where the content of the cell is showing. Place your cursor in between words where you want to put the line break.
  • Now, press Alt+Enter.

Alt+Enter to make two lines in one cell

You will see two lines have been formed in the cell. However, the row height is still not up to the desired length, so the Book name is still not showing properly. That means we have to adjust the row height.  But before that, add line breaks to every cell’s content, following the same process explained above.

  • Next, select all the cells as we selected B6:B9. Then go to the Home tab and select Format from the Cells Finally, select Autofit Row Height.

Autofit to make two lines in one cell

As a result, the cells will show the entire content in two lines perfectly.

Method 2

2. Utilizing Wrap Text

We can construct two lines in one cell by utilizing the Wrap Text which is a built-in feature in Excel. The steps are as below.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select all the cells where you want to make two lines. In our case, the cells will be B6:B9.
  • Now, go to the Home tab, and from the Alignment group, select Wrap text.

Wrap text to make two lines in one cell

Consequently, your contents in the cells will be in two lines each.

  • Finally, to adjust the row height, press Alt, H, O, and A respectively, or you can follow the previous method described in Method 1.

See, your job is done in one swoop.

Method 3

3. Using Merge & Center

We can also use Merge & Center feature from the same group along with Wrap Text.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select the cell where your text is. As you can see, the Book name in the B6 cell is overlapped with the adjacent cell C6.So we will select both cells B6 and B7.

  • Next, we will apply Merge & Center from the Alignment group found in the Home tab.

Merge & center to make two lines in one cell

  • As you can see, the content is now in one cell. But it still needs to show the whole text. So we will select Wrap text from the same group.

wrap text to make two lines in one cell

Now the texts are in multiple lines to show the whole content.

Method 4

4. Employing Find and Replace

For large sets of data, you can use a comma in place of a line break. Then, with the help of Find and Replace, you can replace the comma with a line break. Let’s show you the procedure.

⬇️⬇️ STEPS ⬇️⬇️

  • First, Type your table content with a comma in the place where you want your line breaks as we did. You can see we put a comma(,) “The Wind in, the Willows” in-between ‘in’ and ‘the’.

Putting comma to make two lines in one cell

  • Next, select the cells as we did here, selecting B6:B9.
  • Subsequently, press Ctrl+H. Thus, a Find and Replace dialogue box will show up.

Find and Replace to make two lines in one cell

  • Then, in Find what box, put Comma(,) and in Replace with box, instead of typing anything press Ctrl+J. Finally, press Replace All.

  • A pop-up box containing the replacement results will appear. Press OK and then Close the Find and Replace box.

You will be happy to see two lines have been formed in each cell. Of course, you will have to adjust the row height according to the method described in Method 2.


How to Remove Line Breaks in Excel

If you ever need to remove line breaks in Excel, you can just reverse the last method described in the article. Let’s see the steps in action.

⬇️⬇️ STEPS ⬇️⬇️

  • Select all cells where line breaks should be removed or replaced.
  • Then, to enter the Find and Replace dialog box, use Ctrl+H.

Ctrl+H to make two lines in one cell

  • Enter Ctrl+J in the Find What It will appear empty, yet there will be a little dot. Enter nothing but a space in the Replace With area to replace line breaks.

  • Enjoy the outcome by pressing the Replace All button. Excel will show the amount of replacement it did.

The result:


📝 Takeaways From This Article

📌  We discussed a keyboard shortcut to make two lines in one cell in Excel.

📌  Two Ribbon feature was discussed to achieve the same goal.

📌  Finally, we showed how users can use Find and Replace to make two lines in one cell in Excel.


Conclusion

We have come to the end of our article. We hope that you understood, and from now on, you will excel at making two lines in one cell without much effort. Feel free to comment below, if you have any queries, and for more tutorials like this, visit Excelden.com.

(Visited 49 times, 1 visits today)
Hassan Shuvo

Hassan Shuvo

Hello, I am Mehedi Hassan Shuvo.I am an Engineering graduate from Bangladesh University of Engineering and Technology. I love reading Thriller books, watching Anime, and playing Cricket. I also love learning about new software. Excel is one of my favorite ones by far. My efforts will be worthwhile if I can utilize my expertise to assist anyone. If you find any faults in my writing please let me know.I will try to correct them as I am learning everyday.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo