Prantick Bala
If you have long text in any Excel cells, it becomes difficult to read and your Excel sheet looks disorganized. You can easily wrap the text in a cell by following some easy techniques. In this article, I’ll introduce you to 5 easy ways to do the job.
Download Practice Workbook
You can download the Excel file and practice while reading this article.
5 Easy Ways to Wrap the Text in a Cell in Excel
Look at the following dataset. Here, we have five products and descriptions for each product. The cells for product description have a lot of text which have crossed the border of each cell. Now we have to wrap these texts in respective cells. In the following article, we will describe 5 easy methods to do the task smoothly. Here, we used Excel 365. You can use any available Excel version.
1. Using Wrap Text Feature to Wrap Texts
You can easily wrap the text in a cell by using the Home Tab.
Steps:
- First, select all the cells in which you want to wrap the text.
- Here, we selected cells C5:C9.
- After that, go to the Home tab >> from the  Alignment group >> select Wrap Text.
- After that, you will see the texts have been wrapped, however, the texts need adjustment in a cell.
- Then, to adjust the text in a cell, we have to double-click between the rows of the text box.
- See the following picture.
- Furthermore, we will do this for each cell that has unadjusted text.
- As a result, it will wrap the texts in every cell you have selected.
Read More: [Fix] Wrap Text Not Working in Excel: 4 Possible Solutions
2. Use of Format Cells Feature
Another way to wrap the text in a cell is using Format Cells. Here, we will use this feature.
Steps:
- First of all, select all the cells in which you want to wrap the text.
- Here, we selected cells C5:C9.
- Then, we will right-click on the selected cells >>select Format Cells from the context menu.
- After that, the Format Cells dialog box will appear.
- Then, go to Alignment >> check in the Wrap Text box >> click on OK.
- Therefore, the texts will be wrapped in the corresponding cells.
3. Employing a Keyboard Shortcut
The easiest way to wrap the text in a cell is by using a keyboard shortcut.
Steps:
- In the first place, select the cells in which you want to wrap texts.
- Here, we selected cells C5:C9.
- Then, we press ALT+H+W.
- As a result, you can see the wrapped text.
Read More: Wrap Text in Excel Shortcut Key
Similar Readings
4. Applying Line Breaks to Wrap Text in a Cell
You can wrap the text in a cell by applying Line break manually.
Steps:
- In the first place, click on cell C5 >> put the cursor to the point where you want to insert a line break.
- Here, we put the cursor before the text Available.
- Then, press ALT+ENTER.
- Therefore, your text from that point will move into the next line.
- In this manner, you can wrap the text in all the cells by manually inserting a line break.
5. Wrapping Texts of a Merged Cell
Merging cells convert multiple cells into a single cell. If you have a Merged cell in your Excel sheet, you have to unmerge the cell first for wrapping the text.
Steps:
- To unmerge the cells, in the beginning, click on the merged cell C5:F5 >> go to the Home tab.
- Then, from the Alignment group >> select Merge & Center box.
- Repeat this for other merged cells as well.
- As a result, the cells will be unmerged and the Merger & Center box is not highlighted anymore.
- After that, we follow Method-1 to warp the text of cells C5: C9.
- Therefore, you can see the wrapped cells.
Read More: How to Wrap Text in Merged Cells in Excel (5 Ways)
How to Remove Wrap Text Formatting from a Cell in Excel
Here, we will demonstrate to you how you can remove the wrap text formatting of a cell in Excel.
Steps:
- First, select the cells that have wrap text.
- Here, we selected cells C5:C9.
- Then, go to the Home tab >> from the Alignment group >> select Wrap Text.
- Therefore, this will remove the wrap text format from the selected cells.
- Hence, you can see the wrap text formatting has been removed from the cells.
Practice Section
You can download the above Excel file and practice the explained methods.
Conclusion
Here, we show you 5 easy methods to wrap the text in a cell in Excel. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section. You can visit our website Exceldemy for more related articles.
