Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How Do You Wrap The Text in a Cell in Excel (5 Easy Ways)

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.

Dataset to Wrap the Text in a Cell in Excel


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.

Using Home Tab to Wrap the Text in a Cell in Excel

  • 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.

Use of Format Cells Feature to Wrap the Text in a Cell in Excel

  • 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.

Employing Keyboard Shortcut to Wrap the Text in a Cell in Excel

  • 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.

Applying Line Break to Wrap the Text in a Cell in Excel

  • 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.

Wrapping Text of a merged Cells in Excel

  • 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.


Related Articles

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo