Question

this option accommodates the text automatically within the column width by increasing the row height​

Answer 1

Answer:

Change the column width to automatically fit the contents (auto fit) Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width.