S,

You'll need wrap text turned on (Format - Cells - Alignment tab - Wrap
text). You'll need the row set to Autofit (Format - Row - Autofit). Now
the row height will adjust to the amount of text. If you manually adjust
the row height, autofit will be turned off.
Be aware of the limitations Mike referred to, if you have large amounts of
text. You may need some line-feeds (Alt-Enter) throughout your data if the
text amount is large.
--
Earl Kiosterud
www.smokeylake.com

"s.gun" wrote in message
...
im tryin to format a cell so that it automatically gets bigger if i type a
large amount of text.
can ne1 help?? thanx a lot