Thanks for the explanation on when the Shrink to Fit is unavailable. I
have been using ALT-Enter and wrap text and it was causing the Shrink
to Fit from being available.
Thanks again.

Nick Hodge Wrote:
There may be other reasons, but there is not a global setting. It
certainly
becomes unavailable when there is a hard line feed (Alt+Enter) and when
the
setting 'wrap text' is on

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"jzapatka" wrote in message
...-

I have not been able to locate an answer for my Excel annoyance. Why
is
it that when you go to Format Cells -- Alignment -- Text Control that
the Shrink to Fit checkbox is sometimes grayed out? Is there some
sort
of global control that prevents this, or is it more mundane?
Thanks for the help.


--
jzapatka-


--
jzapatka