Excel 2010: How To Fit Column/Row Height & Width

While entering data in Excel 2010 spreadsheet, sometimes we forget to set the height/width of row and column. The AutoFit Row Height and AutoFit ColumnWidth are two handy options which you can use to quickly set the height and width of row and column respectively.

To quickly set the height & width, select the cell(s) and navigate to Home tab, under Cells group, open Format options. Click AutoFit Row, it will set automatically set row height to minimum, and same with the case for clicking AutoFit Column Width.

Now width & height of selected column(s) and row(s) is set to minimum.