Change The Column Width And Row Height - Microsoft Support

  1. Select the row or rows that you want to change.

  2. Go to Home > Cells > Format.

    On the Home tab, click Format

  3. Under Cell Size, select AutoFit Row Height.

    Tip: To quickly autofit all rows on the worksheet, select Select All, and then double-click the boundary below one of the row headings.

Select All button

Tag » How To Get All For One