I thought Donna meant to have this adjustment occur without any action by
user. Of course you can select the columns and use Format settings manually,
to automate would require VBA or macro.

"June7" wrote:

Do you mean to adjust the width? Not that I know of. Would have to build
code to handle that. You can set cell Format/Alignment property to wrap text
and the row height will expand to acommodate the wrapped text.

"Donna" wrote:

Is there a way to format an Excel worksheet to "autofit to contents" the way
it works in a Word table?