Auto-fit Columns Using Macros
If you want to make your columns more presentable in your excel then use macros to auto-fit them. We understand in excel column widths are all over and that does not look cool and presentable.
Purpose of this tutorial: to learn how to Auto-fit all columns by using macros to fit to its contents in excel.
Before following the procedure of this tutorial make sure you have enabled the Excel’s Developer Tab.
STEP 1: GO TO DEVELOPER> CODE> VISUAL BASIC> COPY/PASTE THE CODE BELOW > CLOSE THE WINDOW
Copy The Code Below;
‘See the magic happen!
STEP3. Now open the sheet that contains the data to test it out.
Afterwards, follow this: Go to Developer > Code > Macros > Run
Now all of the columns are automatically fitted.