How to Wrap Text in Excel Cell (4 Simple Ways)

If you are looking for how to wrap text in an Excel cell, then you are in a right place. Without wrapping text in MS Excel, it can look incomplete and be read tediously. In this article, you are going to learn 4 easy and effective methods to do wrap text in Excel cells.


Download Practice Book

Download the following Excel file for your practice


What Is Wrap Text in Excel?

Wrapping text means enclosing long text or sentences in a cell or merged cells. While preparing a report, or maintaining a database, we often have to type long text in Excel cells. Excel shows these long texts over the borders of the cells. The Wrap Text option provides us with the facility to display this kind of large content within the designed size of Excel cells.

See the following images to get a clearer idea.

What Is Wrap Text in Excel?


4 Easy Ways to Wrap Text in Excel Cell

Here, we pick a data set containing 3 columns. Our mission is to wrap up the texts so that the text will be easy to view at a glance.

Sample dataset to show how to wrap text in Excel cell

Now let’s explore the methods one by one.


1. Use a Keyboard Shortcut

If you want to wrap the text in your Excel spreadsheet in the quickest way, the keyboard shortcut is the best method for you. But, Excel does not provide any direct shortcut keys to wrap text but rather uses a combination of the Alt+H+W hotkeys.

Steps:

  • First, select the range of cells that contain text that you want to wrap, e.g. we have selected B5:D7 here.

Use a Keyboard Shortcut to Wrap Text in Excel

  • Then press ALT+H+W.

The output is as follows.

Fix Row Height to Make the Wrapped Text Completely Visible:

We can see from the above screenshot that we have wrapped the text successfully within a cell. But the text is not visible as the row height or column width is not enough. However, we can autofit the row height in two ways: using keyboard hotkeys, or using the Format option.

  1. Hotkeys: Alt+H+O+A. Select the cells whose row height you want to autofit. Then press these hotkeys one by one.
  2. Format option: Go as follows- Select the cells >> go to the Home tab >> the Cells group >> the Format drop-down >> select the AutoFit Row Height option.

Fix Row Height to Make the Wrapped Text Completely Visible

In both ways, the result will be as follows.

Use a Keyboard Shortcut to Wrap Text in Excel Cell 2

Note:

For the entire spreadsheet, you can select the whole sheet by clicking Ctrl+A and then wrap text by pressing Alt+H+W.

Read More: Excel VBA: Autofit Row Height with Wrap Text (5 Effective Ways)


2. Use the Excel Wrap Text Button

The Wrap Text button is the most frequently used and easiest method to wrap up a text in MS Excel. 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.

Use the Excel 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.


Similar Readings


3. Utilize the Format Cells Dialog Box

All the formatting options are available in the Format Cells dialog box. So you can wrap text too using this awesome Excel feature. Here are the steps to follow.

Steps: 

  • Select the cells that contain texts and right-click the mouse.
  • After that, go to the Format Cells dialog box from the context menu or press CTRL+1.

Choosing Format Cells option in Excel from the Context Menu

You can also use the Number Format button from the Number group.

MS Excel Number Format Button from the Number Group

A pop-up window will appear.

  • Go to the Alignment tab >> mark the Wrap Text checkbox.
  • Finally, press OK.

Wrap Text in Excel from the Format Cells Dialog Box

  • Use Alt+H+O+A to fit the row height and make the wrapped text clearly visible.

We can see the result in the following image. 👇

Read More: How to Wrap Text across Multiple Cells without Merging in Excel


4. Apply Line Breaks to Wrap Text Manually

If you want to wrap text manually, you can use line breaks. To use a line break in an Excel cell, you have to press the Alt+Enter keys together. The following steps will show in detail.

Steps:

  • Double-click the cell containing the text in which you need to enter a line break. Or press F2 after selecting the cell.
  • In the cell box, select and click the place where you need to break the sentence line.

Apply Line Breaks to Wrap Text in Excel Manually

  •  And then, press ALT+ENTER.

Select and apply Alt+Enter everywhere you want to place the line breaks, and thus wrap the text within the cell.

  • Finally, press Alt+H+O+A to autofit the row height.

Here is the result.

Results of Line Breaks to Wrap Text Manually

Read More: How to Make Text Automatically Wrap Around in Excel (5 ways)


How to Remove Text Wrapping from Excel Cell

We have learned how to wrap text in an Excel cell so far. Now in this section, we will also tell you how to undo the wrap text format from your Excel workbook.

It’s easy to remove wrap text in Excel cell. Just select the cells containing texts that you need to remove from the wrapped format, then apply any of the following 3 ways.

  • Go to the Home tab, and then press the Wrap Text button from the Alignment group.

Or,

  • Right-click the mouse >> go to Format Cells from the context menu >> unmark the Wrap Text checkbox from the Alignment tab.

Or,

  • Apply the ALT+H+W keyboard hotkeys.

Read More: How to Unwrap Text in Excel (4 Methods)


Things to Remember

  • All the Wrap Text methods just enclose the texts within the cell with the current column width and row height. But you have to autofit the row height using the methods described in this article (Alt+H+O+A hotkeys, or the Format option) to make the texts completely visible.
  • If you change the column width and the text becomes difficult to see, autofit the row height again in the same way.

Conclusion

In this article, I have discussed 4 easy methods of how to wrap text 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.


Related Articles

Hafiz Islam
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo