Auto-fit Rows Using Excel Macros
Row heights sometimes really not look presentable so, if you are wondering to auto-fit all of your rows within simple ways then just do it by using Macros in your Excel. With macros it will be done by only one click.
Purpose of this tutorial: to learn how to Auto-fit all rows 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!
STEP2. Now test it in your excel by doing this:
First, open the sheet that contains the data and then
Go to Developer > Code > Macros > Run
Now all of the rows automatically get fitted just after clicking Run.