Automatic Cell Fit

[Wendy Reeves]

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

 

[Dave Peterson]

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$1uzL1BHA.1784@tkmsftngp05

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