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.


How to Put Multiple Lines in Excel Cell: 2 Easy Ways

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 Enter within a Cell in Excel 


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: Excel: Inserts New Line in Cell Formula 


Download Practice Workbook

Download the following Excel file for your practice.


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. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles


<< Go Back to New Line | Text Formatting | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hafizul Islam
Hafizul Islam

Hafizul Islam is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo