-
Select the cell or range of cells to adjust height or width automatically.
-
On the Home tab, select Format.
If you don't see Format, select Cells first. -
Select Auto Fit Row Height or Auto Fit Column Width.
For more info, see Change column width or row height.
-
Select the cell or range of cells to adjust height or width automatically.
-
On the Home tab, select Format.
If you don't see Format, select Cells first. -
Select AutoFit Row Height or AutoFit Column Width.
For more info, see Change column width or row height in Excel for Mac.