Autofit Row Height / Column Width in Excel

How to autofit row height or column width in Microsoft Excel 2013?

Explanation

To Auto fit the cells, use the steps given below.
To Autofit Row Height:
Step 1: Click Cells under HOME tab.
Step 2: Click the drop down near the Format icon and select Auto Row height to adjust the row automatically to the default sizes.
autofit row height ms excel 2013
To Autofit Column Width:
Step 1: Click Cells under HOME tab.
Step 2: Click the drop down near the Format icon and select Auto Column Width to adjust the column automatically to the default sizes.
autofit column width ms excel 2013


Related Topics