Automatic Cell Fit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy Reeves - 17 Oct 2003 14:28 GMT

Hello Everyone:

I have created a spreadsheet in Excel, and have set cells
to wrap text automatically. The problem is that the cells
do not expand vertically to accomodate larger amounts of
text. Is there a way to do this?

Thanks,

Wendy

Reply to this Message

Dave Peterson - 18 Oct 2003 00:41 GMT

If you've set the rowheight manually, then excel will respect that and not
automatically adjust the rowheight when you add/delete text.

But if you Format|row|autofit, excel will adjust whenever necessary.

That said, excel won't automatically fix rows that have merged cells.

If you have merged cells, you may want to use Jim Rech's macro:

http://groups.google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> Hello Everyone:
>
[quoted text clipped - 6 lines]
>
> Wendy

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message