How to Use AutoFit Tool in Excel

Select the Data to AutoFit
1. Open the Excel workbook.
2. Select an entire worksheet by clicking the square in the top left corner.
3. Select a column by clicking the letter at the top of the column.
4. Select a row by clicking the number of the row on the left side of the spreadsheet.
5. Select an individual cell by clicking the cell.
6. Select multiple sequential columns, rows or cells by left-clicking on the first item, holding down the mouse button and dragging the mouse to include the items you want. Then release the mouse button.
7. Select multiple non-sequential columns, rows or cells by holding down the 'Ctrl' key while you make your selections using the instructions above.
Use AutoFit
8. Navigate to the Home tab on the top menu and look for the 'Cells' section.
9. Find the 'Format' button in the 'Cells' section and click it to reveal the drop-down menu.
10. Select 'AutoFit Column Width' to adjust the column width automatically. If you selected a worksheet, each column's width will adjust to fit the widest item in it. If you selected a column, the column width will adjust to fit the widest item in it. If you selected a row, each column's width will adjust to fit the widest selected cell in each column. If you selected one cell, the column width will adjust to fit the one cell.
11. Select 'AutoFit Row Height' to adjust the row height automatically. If you selected a worksheet, each row's height will adjust to fit the tallest item in it. If you selected a row, the row height will adjust to fit the tallest item in it. If you selected a column, each row's height will adjust to fit the tallest item in the selected cell in each row. If you selected one cell, the row height will adjust to fit the one cell.
12. Adjust the width of a column by selecting the column using the address at the top of it, and double-click on the line on the right side of the first column address selected.
13. Adjust the height of a rows by selecting the row using the address to the left of it, and double-click on the bottom line of the first row address selected.