How to wrap text in Excel [step by step]

June 1, 2022

When you work with a large spreadsheet containing a lot of text that needs to be displayed, long sentences or data strings will either spill over on top of other empty cells on the right or cut off at the cell border if the adjacent cell contains data. This is why it's important to learn how to wrap text in Excel.

Long text without text wrapping

What is wrap text in Excel?

The wrap text feature expands the cells vertically to accommodate all the data on multiple lines. If you're frequently copying data into an Excel spreadsheet, the wrap text option is helpful because when you paste data into a cell with wrap text formatting enabled, Excel automatically adjusts the width and height of the cell to show all the content.

Where is wrap text in Excel?

There are two ways to activate the wrap text option: the Excel ribbon menu and the Format cells menu. I have covered both in this tutorial, along with the keyboard shortcut that enables text wrapping.

How to wrap text from the Ribbon menu

There are several ways to use the Wrap Text option, and the easiest one is from the Excel ribbon. To wrap the text:

1. Select the cells or range of cells you want to format.

2. Go to the Home tab and click the Wrap Text link from the Alignment section.

How to wrap text in Excel with the Wrap Text button from the Alignment section

If you wrap text in cells, the data will automatically adjust to appear on multiple lines within the cell. A wrapped cell expands as you type into it, so it will always display everything you type. 

Text wrapped in Excel

The data wraps to fit the column width automatically, but you can also adjust the width so that the text naturally fits the column width, either by double-clicking the right border of the column header or dragging the column handle.

How to adjust column or row size in Excel

You can also do the same to change the row height by double-clicking the bottom border of the row header.

How to wrap text using a keyboard shortcut

An alternative option is to use a keyboard shortcut to wrap the text inside the cells. To use this method:

1. Highlight the cells or range of cells you want to format.

2. Press ALT, H, W to apply wrap text formatting. The text wrapping will be automatically applied.

Note: You need to press the keys in consecutive order, not all at once.

Keyboard shortcuts are great because they improve the speed at which you perform actions. I strongly encourage you to learn at least some basic keyboard shortcuts. You'll soon see that your productivity increases, and you'll be more inclined to test other shortcuts.

How to wrap text using the Format Cells dialog box

Text wrapping is just another formatting option. You can adjust all the cell formatting from the Format Cells dialog box.

1. Right-click on the cells or range of cells you want to format.

Tip: You can also press CTRL + 1 to open the Format Cells dialog box.

2. Choose Format Cells.

Select Format Cells from the right-click menu.

3. Check the Wrap text box under the Text control section on the Alignment tab.

Select Wrap text from the Alignment tab of the Forma Cells dialog box.

4. Click OK.

Adjusting the cells in the Format Cells dialog box is a better approach if you intend to apply additional formatting rules besides the text wrapping.

Note: A cell that has text wrapping enabled will wrap text automatically until the format is changed or overwritten.

How to wrap text in Excel by adding line breaks

Adding line breaks will automatically adjust the format of your text based on the available width of the cell. This also prevents the column width from getting wider. To do this, simply follow the steps below:

1. Place the cursor in the text at the point where you want to add a line break.

Adding line breaks to wrap text in Excel.

2. Hold the ALT key and press ENTER.

Text breaks on multiple lines.

This will add a line break character into your text data and move the remaining text down by one line. You can do this multiple times per cell until you are satisfied with the way your text is displayed.

How to adjust the row height to make wrapped text visible

Sometimes, the text may not be visible because the wrapped text is still too long to fit inside the cell. The limitation of Excel cells will only display the first 1,024 characters. The remaining text is cut off at the border of the cell below. To display the full content, you can increase the row height manually by clicking and dragging the row, but you can also auto-adjust the height by following the steps below:

1. Select the cells or range for which you want to change the row height.

2. Go to the Home tab and click the Format menu in the Cells group.

Select Format from the Cells section.

3. Under Cell Size, click AutoFit Row Height from the drop-down menu to modify the row height automatically.

Select the AutoFit Row Height option.

4. If the cells need to have a fixed size, click Row Height under the Cell Size, and type the desired size in the row height box.

The row height will adjust to the exact height needed to show all the text. You can also do the same to adjust the column width by choosing Column Width under the Cell Size and specifying the exact width.

How to remove wrap text formatting

Remove cell formatting

Select the cells or range of cells from which you want to remove the formatting and unwrap the text. Then, navigate to the Home tab and click Wrap Text in the Alignment section to deselect the option.

Alternatively, you can open the Format cells window by pressing CTRL + 1 or right-clicking on the cell or range of cells from which you want to remove the formatting. Then, on the Alignment tab, uncheck the Wrap text box under the Text control section and click OK.

If you prefer a keyboard shortcut, you can press ALT, H, W to remove the wrap text formatting.

Remove line breaks

If you are looking for a quick method to remove the line breaks and the wrap text formatting, follow these steps:

1. Go to the Home tab and click Find & Replace in the Editing group.

Tip: You can also press CTRL + H to open the Find & Replace window.

2. Place the cursor in the Find what section and press CTRL + J to add a line break character.

3. Leave the Replace with section empty to remove the line break characters that were added manually.

4. Click Replace All.

What to do next?

Text wrapping greatly improves the way your Excel data is presented, enhancing the readability of your spreadsheet and making data easier to understand. Now that you've learned how to wrap text in Excel, there are other helpful Excel tips and tricks that you can apply at work. I recommend further improving your formatting skills by reading the following articles:

About me
Radu from ExcelExplained

My name is Radu Meghes, and I'm the owner of excelexplained.com. Over the past 15+ years, I have been using Microsoft Excel in my day-to-day job. I’ve worked as an investment and business analyst, and Excel has always been my most powerful weapon. Its flexibility and complexity make it a highly demanded skill for finance employees. I launched excelexplained.com back in 2017, and it has become a trusted source for Excel tutorials for hundreds of thousands of people each year.

If you'd like to get in touch, you can contact me on LinkedIn.

Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

Essential Functions

Popular Articles

Excel courses

I have compiled a list of the best Excel online courses. It covers basic and advanced topics, VBA, and Power BI.
View courses
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2022 ExcelExplained.com
>