-
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 the column width and 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  More Options 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.