shrink to fit does it creat a new format in a cell if the text shrinks?
From the following article:
XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/?scid=kb;en-ca;213904
--A combination is defined as a unique set of formatting elements that
are applied to a cell.
From the following article:
XL: Controlling and Understanding Settings in the
Format Cells Dialog Box
http://support.microsoft.com/?scid=kb;en-ca;264372
--"Selecting the Shrink to Fit option decreases the font size of the
text in a cell until all the contents of the cell can be displayed...The
applied font size is not changed."
So, I'd guess that two cells with identical formatting, including
"Shrink to Fit", would have the same format "combination", even if the
text in one appears smaller, due to column width.
Quote:
> does the shrink to fit option in a cell creat a different format in a cell
> if the text is big and this has to be shrunk?
> i.e. if font size in cell is set at 10 then the text is bigger than the
> cell , does the font size change to say 8? or something like that .
> the reason i am asking is that i am trying to ruduce the amount different
> formats in my workbook as i have come up with the error to many diffrent
> formats , so ther for need to reduce the formats and was wondering if this
> was creating a different fornat if the text length is bigger than the cell
> making the font size smaller.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html