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.
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.
- 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 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.
- Now to make the text visible within the wrapped cell, apply the hotkeys Alt+H+O+A.
Here is the final output.
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