Shrink to Fit

[jzapatka]

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

[Nick Hodge]

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
[email protected]HIS


"jzapatka" <[email protected]> wrote in message
news:[email protected]...
>
> 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

[kenvarl]

I came across this site because I had the same problem (Office 2013)

The reason that my "Shrink to Fit" was greyed out was because the Horizontal Alignment was set to "Fill"

I set it to "General", and the "Shrink to fit" became available again.

Hope this helps someone.

[FHPamela]

I found 'Scale to Fit' was greyed out because Height: needed to be set to Automatic.