Excel AutoFit
The AutoFit in Excel is done by either dragging the column border to your liking or double-clicking at the border. Let’s take a few examples and learn more about these step by step.
AutoFit Width of a Column
1. To change the width of a column, drag the right border of the column header to your liking.
![drag excel column](https://overallmoney.com/wp-content/uploads/2022/03/autofit-1.png)
2. Double click on the right border of a column header that you like to automatically autofit.
![autofit excel](https://overallmoney.com/wp-content/uploads/2022/03/autofit-2.png)
3. To autofit multiple columns at a time, first select multiple columns by their column headers.
![select multiple columns to autofit](https://overallmoney.com/wp-content/uploads/2022/03/autofit-3.png)
4. Double click the right border at one of the column headers.
![autofit multiple columns](https://overallmoney.com/wp-content/uploads/2022/03/autofit-4.png)
AutoFit Height of a Row
To adjust the height of a row, follow similar steps as above. Let’s take an example,
1. To autofit all row heights at the same time, select all rows by their headers.
![autofit excel rows](https://overallmoney.com/wp-content/uploads/2022/03/autofit-5.png)
2. Double click on any one of the row boundaries.
![autofit multiple rows](https://overallmoney.com/wp-content/uploads/2022/03/autofit-6.png)
We can also autofit row height or column width using the Excel menu.
1. Go to the cells group on the Home tab, click Format.
![excel format command on Hobe tab](https://overallmoney.com/wp-content/uploads/2022/03/autofit-7.png)
2. Click “AutoFit Row Height”.
![autofit row height](https://overallmoney.com/wp-content/uploads/2022/03/autofit-8.png)
We get the following result.
![excel autofit row](https://overallmoney.com/wp-content/uploads/2022/03/autofit-9.png)
Using the techniques described above, we hope that you now can autofit any excel column width or row height the way you want.
6 of 12 finished! Recommending more on the Range: Next Example >> |
<< Previous Example | Skip to Next Chapter 03: Understanding Workbook |