right click on the cell that needs to shrink, click format cells, then
under the alignment tab, check "shrink to fit" at the bottom of the
page.
--
flyingmeatball
------------------------------------------------------------------------
flyingmeatball's Profile:
http://www.excelforum.com/member.php...o&userid=37302
View this thread:
http://www.excelforum.com/showthread...hreadid=572757