How to Unwrap Text in Excel (4 Methods)

Get FREE Advanced Excel Exercises with Solutions!

Firstly, Spreadsheet software like Microsoft Excel deals with numbers. But in some cases, you find yourself in a position where you need to store a large amount of text in Excel and some of the texts don’t fit in the cells properly. Yes, you can do it by making the column wider. But when you need to display a major portion of your dataset, you find a lot of difficulties. The most accurate way is to use the wrap text option. Now, all of a sudden you need to unwrap text in Excel. This article will give a proper guideline on how to unwrap text in Excel in an efficient way.


Download Practice Workbook

Download this practice workbook


What Is Wrap Text in Excel?

In Microsoft Excel, wrap text can be defined as a feature through which a cell shows all the information that you entered even if it overflows the cell boundary. The wrap text feature enhances the cell width according to the required size. To have a better understanding, take a closer look at the following example

Here, in cell ‘B4’ & cell ‘C4’, we get different alignments. As we used to wrap text feature in cell ‘C4’, it enhanced the column width and showed all the text in two lines whereas, in cell ‘B4’, we didn’t use the wrap text feature which is why the text is cut off at the cell border.


4 Methods to Unwrap Text in Excel

This article will particularly cover 4 different methods where two of which are by using excel functions and the other two are by using VBA codes to unwrap text in Excel. All four methods are fairly easy to unwrap text. To show these methods, we take a dataset that includes the book name and author.

How to Unwrap Text in Excel


 1. Unwrap Text Using Home Tab in Excel

As we have a dataset that used the wrap text feature previously and we need to unwrap text in this dataset. The first and the most common way is to use a ribbon option from the Home tab.

📌 Steps

  • Firstly, select the required cell to unwrap

How to Unwrap Text in Excel

  • Secondly, go to the Home tab in the ribbon, and in the ‘Alignment’ section, wrap text will appear. Click on the wrap text

  • There we have it. Now, we find the text in a situation where it is cut off at the border of the cell, which means wrap text is not applied anymore.

How to Unwrap Text in Excel

Read More: Wrap Text in Excel Shortcut Key (2 Hotkeys)


2. Unwrap Text Using Format Cells

Our next method to unwrap text in Excel is by using Format cells. To open the Format cells, you can use following 3 ways:

Keyboard Shortcut:

Press the ‘Ctrl + 1’ button, and the Format cells box will pop up.

Format Cells Option:

Select the text which you want to unwrap and right-click on the selected text cell, several options will appear from which Format cells need to be selected.

From Home Tab:

Select the ‘Home’ tab in the ribbon, in the ‘Home’ tab there is a Cells section from which the Format option needs to be selected.

📌 Steps

  • Now, use any of your preferred ways to open Format Cells. We open Format cells from the Home

  •  Then Click on ‘Format’ from the cells section. A Format cells box will pop up instantly. In the Format cells, check on the alignment tab and uncheck the Wrap text.

  • This will remove the Wrap text feature from the selected cell.

How to Unwrap Text in Excel

Read More: How to Wrap Text in Merged Cells in Excel (5 Ways)


3. Unwrap Text Applying VBA Code in Excel

You can use Visual Basic for unwrapping your text. To do this you need to follow the steps:

📌 Steps

  • Primarily, you need to open the ‘Developer Tab’. If you don’t have ‘Developer Tab’, you can include this in the ribbon by Customizing the Ribbon option, or for a keyboard shortcut press ‘Alt+F11’. Then the VBA interface will appear.
  • In the VBA interface, select the ‘Insert’ tab in which you’ll get the ‘Module’ option. Click on it.

  • Then, in the Module window, write down the following codes:
Sub Unwrap_Text()

'unwrap text in cell B5 in worksheet named Using_VBA

Worksheets("Using VBA").Range("B5").WrapText = False

End Sub
  • Select the View tab in which you’ll see the Macro You can get this Macro option from the Developer tab also.

  • Now select the ‘Unwrap Text’ from Macro window and click ‘Run’

How to Unwrap Text in Excel

  • All the wrap text features will disappear and you’ll get unwrapped text.

How to Unwrap Text in Excel

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


4. Unwrap Text in Selected Cells Applying VBA Code

Finally, we use VBA code for a cell to unwrap. Now, you would like to do it for multiple cells. You can follow this method step by step to do this.

📌 Steps

  • Just like the previous method, open the Developer tab. Then open the Module option along with the Insert tab. In the Module window, write down the following code.
Sub Unwrap_Text_for_cells()

'unwrap text in selected cells

Range("B5:C5").WrapText = False

End Sub
  • Now open the Macro option from the View tab or Developer Select ‘Unwrap_Text_for_cells’ and click on ‘Run’.

  • By doing this, we can easily unwrap text for multiple selected cells.

Read More: [Fix] Wrap Text Not Working in Excel: 4 Possible Solutions


Conclusion

We have discussed 4 methods to unwrap text. All of them are fairly easy to use and equally effective. This will eventually become a one-stop solution for unwrapping text in Excel. If you have any questions then comment below and for further knowledge visit Exceldemy.


Related Articles

Durjoy Paul

Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo