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.
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.
- Firstly, select the required cell to unwrap
- 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.
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:
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.
- 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.
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:
- 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’
- All the wrap text features will disappear and you’ll get unwrapped text.
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.
- 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
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.
- [Fix]: Excel Wrap Text Cutting off Words
- How to Make Text Automatically Wrap Around in Excel (5 ways)
- Excel Auto Fit Row Height for Wrap Text (4 Methods)
- [Fixed] Wrap Text Not Showing All Text in Excel (4 Solutions)
- [Solution:] Excel Wrap Text Not Working for Merged Cell
- How to Wrap Text across Multiple Cells without Merging in Excel