Highlight the row you would like to change the column width for. Double-click on the right side of the column. 

The column will then automatically adjust to the size needed by the text in the column.

Click on the side of the column, hold down the edge of the cell and you can then drag to expand or shrink the width of the column.

office.com

This guide provides step-by-step instructions on how to adjust column widths and row heights in Excel. It includes methods for autofitting and manually adjusting single columns, formatting all columns and rows in a sheet, adjusting row heights, and changing the default row height. It is a helpful resource for anyone looking to customize the layout and formatting of their Excel spreadsheets.

Adjusting Column Widths and Row Height in Excel

Formatting All Columns and Rows in a Sheet