Question

How do you change the column with to fit the content

Answer 1

Change the column width to automatically

fit the contents (AutoFit):-

1. Select the column or columns that you want to change.
2. On the Home tab, in the Cells group, click Format.
3. Under Cell Size, click AutoFit Column Width.