Automatic Cell Text Wrapping

[Annabelle]

I'm creating a report form in MS Excel 2000 that will use
several formulas and conditional formatting. In a couple
of sections, I've merged several cells into a single line
and selected "Wrap Text". As this form will be used by
many folks, I need this to be an automatic wrap.

Although I'm well within the Excel character limitation
(<800 chars), the line does not wrap. Am I missing
something simple?

 

[Dave Peterson]

I've never had a trouble with text wrapping--but I have had trouble with the
rowheight autofitting.

If that's your problem, too, you can either set it manually or you could use a
macro that Jim Rech wrote:

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