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;
‘Removing your text Wrap
Selection.WrapText = False
‘Autofit all of the cells afterwards
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
Here is your result all of the cells having text wrap removed.