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.
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.
- Put your cursor in the text where you want to insert a new line.
- Press ALT+ENTER to put a new line to the cell.
- Now, you will see a line break. Continue, pressing ALT+ENTER to put more line breaks in your text.
Here is the result,
Read More: How to Do a Line Break in Excel (4 Ways)
- How to Add New Line with CONCATENATE Formula in Excel (5 Ways)
- How to Go to Next Line in Excel Cell (4 Simple Methods)
- Excel VBA: Create New Line in MsgBox (6 Examples)
- How to Add a Line in Excel Cell (5 Easy Methods)
- How to Replace a Character with a Line Break in Excel (3 Easy Methods)
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.
- 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.
- Now to make the text visible within the wrapped cell, apply the hotkeys Alt+H+O+A.
Here is the final output.
Read More: VBA to Generate Multiple Lines in Email Body in Excel (2 Methods)
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.