Remove Text Wrap

The hassles never let you remover all the text wrapping. Do not worry we have a solution for this problem; macros in excel will save you to face hassles while doing this and will remove all the text wrap in your excel and auto-fit your cells very easily.

Before following the procedure of this tutorial make sure you have enabled the Excel’s Developer Tab.

Purpose of this tutorial: Remove the entire text wrap in all cells and then auto-fit all of them.

Previously in Excel Macros: How to Unhide All Worksheets Using Macros in Excel?

STEP 1: GO TO DEVELOPER> CODE> VISUAL BASIC> COPY/PASTE THE CODE BELOW > CLOSE THE WINDOW

Copy The Code Below;

Sub RemoveWrapAndAutofitCells()
Cells.Select
‘Removing your text Wrap
Selection.WrapText = False
‘Autofit all of the cells afterwards
Cells.EntireRow.AutoFit
Cells.EntireColumn.AutoFit
End Sub

Remove Text Wrap

STEP2. We will test it out to show you:

Open that sheet which contains the data and follow this:

GO TO DEVELOPER > CODE > MACROS > RUN

Remove Text Wrap
Before clicking Run ensures that your macro is selected. 

 Here is your result all of the cells having text wrap removed. 

Remove Text Wrap