autofit whole table?

[Lobo]

I'm sick of adjusting cell heights individually! Is there a way to make an
Excel table autofit contents to a cell automatically throughout the
document? I want the widths to stay stable, but the heights of cells to
adjust to the text. I want the whole document to work this way and not have
to go to each individual cell and adjust them. TIA.
~~~~~~~~~~~~~~~~~~~
Delete the obvious to reply to me personally.
~~~~~~~~~~~~~~~~~~~

 

[Gord Dibben]

Lobo

You cannot adjust cell heights individually.

Perhaps you mean "row heights"?

Select your range of rows and Format>Rows>Autofit.


Gord Dibben MS Excel MVP

 

[Mallycat]

I want the whole document to work this way and not have
to go to each individual cell and adjust them.

1) select multiple rows by clicking on the row numbers and draging your
mouse. Select all the rows you want to adjust.
2) move your mouse pointer inbetween any 2 row numbers until the cursor
changes to the black up/down arrow.
3) double click.

Matt

 

[Lobo]

Lobo

You cannot adjust cell heights individually.

Perhaps you mean "row heights"?

yes ... I did mean row heights. Thanks.

Select your range of rows and Format>Rows>Autofit.

Thanks .. will try this.