how to autofit in excel

To autofit columns or rows in Excel, follow these steps:

Select the column or row that you want to autofit.

Double-click the boundary between the selected column or row and the adjacent column or row. Alternatively, you can right-click the selected column or row and choose "AutoFit Column Width" or "AutoFit Row Height" from the context menu.

Excel will adjust the column or row width or height to fit the contents of the cells within it.

Note that if the contents of the cells in the selected column or row change, you may need to repeat this process to keep the column or row properly sized.