Open In App

How to Wrap Text in Excel: In 2 Easy Steps

Improve
Improve
Like Article
Like
Save
Share
Report

Microsoft Excel’s Wrap text allows the content of the cell to appear on multiple lines within a cell; rather than a long line. This feature makes it easy to view the cell content at a glance.

In the below article, we will learn different methods of wrapping text in Excel.

What is Wrap Text in Excel?

When you enter Text in the Cell, sometimes the Content might be longer than the cells’ width. As a result, Excel trims the text and only a part of the whole is visible, leading to an incomplete information display.

Wrapping text allows the entire text to be fully shown within the cell by adjusting the cell’s height to accommodate multiline content ensuring that your data remains organized and easily accessible making your Excel worksheets more informative and user-friendly.

How to Wrap Text in Excel Automatically

This method will help you to convert the long string into multiple lines. To force a lengthy text string to appear on multiple lines, select the cells that you want to format and turn on the Excel text wrap.

Follow the below steps to wrap text in Excel using Ribbon:

Step 1: Open Excel and Select Cell

Select the cell that you want to change.

Wrap Text in Excel

Step 2: Access Home Tab and Select Wrap Text

On the Home tab to the Alignment group and click Wrap Text. You will see that your entered text is now wrapped in the cell automatically.

Click on Wrap Text

How to Wrap Text Using Keyboard Shortcut in Excel

Follow the below steps to wrap text in Excel using keyboard shortcut:

Step 1: Open Excel and Select Cell

Select the cell that you want to change.

Select the cell.

Step 2: Press ALT, H and W

Press Alt + H + W on your keyboard.

Press Alt+H+W

How to Wrap Text in Excel Using Format Cells

Follow the below steps to wrap text using the Format Cells dialog box:

Step 1: Select the cell that you want to change.

Select the cell

Step 2: Right-click on it and click on the Format cell in the drop down menu.

Select format cells

Step 3: Select Alignment in the Format Cells Dialog Box.

Select alignment

Step 4: Check Wrap Text in the Text Control Option and click OK.

Select Wrap Text

How to Insert a Line Break Manually

There may be some instances when you want to start a new line at a specific position within a cell rather than letting lengthy text wrap automatically. For this, you can manually insert a line break in the cell content by following these steps:

Step 1: Select the cell that you want to change.

line-break

Step 2: Place the cursor at the point in the text you want to add a line break.

line-break-1

Step 3: Press Alt + Enter. This will move the text down one line.

line-break-2

Removing Wrap Text via Ribbon

After applying text wrapping you may want to delete it . For removing text wrapping, follow the below steps to remove the text wrap in Excel from the ribbon:

Step 1: Select the cell that you want to unwrap.

Select the cell.

Step 2: On the Home tab, in the Alignment group, click on Wrap Text.

Click on Wrap text

How to Unwrap Text in Excel using Right Click

Follow the below steps to remove wrap text using the format cells dialog box:

Step 1: Select the cell that you want to change.

Select the cell

Step 2: Right-click on Cell and click on the Format cell on the Dialog Box.

Select Alignment

Step 3: Select Alignment, in the Format Cells Dialog Box.

Select- alignment

Step 4: Uncheck Wrap Text in the Text Control option and click OK.

Select wrap text

Alternatively, press the “Ctrl+1” shortcut to open the Format cells dialog and clear the Wrap Text check box on the alignment tab.

Conclusion

In short, wrapping text in Excel makes it easier to read. Just follow the steps of any preferred m,method of your choice given in the article and neatly arrange your data in cells. It’s a simple way to make your Excel sheets look better and be more understandable. You can easily remove wrap text also.

How to Wrap Text in Excel – FAQs

What is text wrapping?

Text wrapping in software like Excel and Word automatically moves text to the next line within a cell when it reaches the cell’s boundary, ensuring all text remains visible without being clipped or extending beyond the cell.

How to Wrap text in multiple cells at once?

To wrap text in multiple cells simultaneously follow the below steps:

Step 1: Select the range of cells you want to wrap text in.

Step 2: Right-click and go to the “Format cells”, and enable “Wrap text”.

How do I AutoFit text in Excel?

To AutoFit text in Excel, select the cell or cells containing the text, then go to the “Home” tab. Click “Format” in the “Cells” group and choose “AutoFit Row Height.” Excel will adjust the row height to fit the text, ensuring it’s fully visible.

What is the shortcut key to wrap text in Excel?

The keyboard shortcut for wrapping text in Microsoft Excel is Ctrl + Alt + Enter.

Why is my text wrap not working properly in Excel?

The wrap text may not be working properly in Excel mainly due to the following reasons:

  • Excel wrap text does not work for merged cells.
  • There will be no change displayed if the cell is already wide enough to display its contents.


Last Updated : 20 Mar, 2024
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads