Unwrap text
How to unwrap content in a cell using Excel and VBA methods
Select the cell in which to unwrap text > Home tab > Alignment group > Wrap Text
| 1. Select the cell in which you want to unwrap text. Note: in this example we are unwrapping cell B2. |
 |
| 2. Select the Home tab. |  |
| 3. Click on Wrap Text, in the Alignment group. |  |
Right-click on the cell in which to unwrap text > Format Cells > Alignment tab > Check Wrap text checkbox > Click OK
| 1. Right-click on the cell in which you want to unwrap text. 2. Select Format Cells. |
 |
| 3. Select the Alignment tab. 4. Uncheck the Wrap text checkbox. 5. Click OK. |
 |
METHOD 1. Unwrap text using VBA
VBA
Sub Unwrap_Text()
'unwrap text in cell B2 in worksheet named Sheet1
Worksheets("Sheet1").Range("B2").WrapText = False
Worksheets("Sheet1").Range("B2").WrapText = False
End Sub
PREREQUISITES
Worksheet Names: Have a worksheet named Sheet1.
Worksheet Names: Have a worksheet named Sheet1.
ADJUSTABLE PARAMETERS
Sheet Selection: Select the worksheet in which you want to unwrap text by changing the Sheet1 worksheet name in the VBA code.
Wrap Text Cell Selection: Select the cell in which you want to unwrap the text by changing the cell reference ("B2") in the VBA code.
Sheet Selection: Select the worksheet in which you want to unwrap text by changing the Sheet1 worksheet name in the VBA code.
Wrap Text Cell Selection: Select the cell in which you want to unwrap the text by changing the cell reference ("B2") in the VBA code.
METHOD 2. Unwrap text in selected cells using VBA
VBA
EXPLANATION
This tutorial explains and provides step by step instructions on how to unwrap text.
This tutorial explains and provides step by step instructions on how to unwrap text.
Excel Methods: This tutorial provides two Excel methods that can be applied to unwrap text. Both of the methods are very similar to each other, with one using the Home tab and the other using the Format cells option. The first method can be accomplished in three steps, whilst the second in five steps.
VBA Methods: This tutorial provides two VBA methods that can be applied to unwrap text. The first method unwraps text in the cells specified in the VBA code. The second method unwraps text the selected cells.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Wrap text | How to fit content in a cell without adjusting column width using Excel and VBA methods | |
| Merge cells | How to merge cells using Excel and VBA methods | |
| Unmerge cells | How to unmerge cells using Excel and VBA methods |