shrink to fit does it creat a new format in a cell if the text shrinks? 
Author Message
 shrink to fit does it creat a new format in a cell if the text shrinks?

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.
any help would be gratefully received. thank you .


Tue, 29 Nov 2005 10:54:49 GMT  
 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


Wed, 30 Nov 2005 13:19:13 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Shrink to fit in merged cells

2. Shrink text to fit

3. Shrink to Fit Text Box question

4. Shrink to fit and wrap text not working?

5. Can Shrink=Yes Will Shrink=no

6. Can Shrink wont shrink

7. Can Shrink won't shrink in ACC 97

8. RTF Format text in Access Report / OLE Object / Can Shrink Can Grow

9. Shrink to fit UserForm?

10. Shrink to fit


 
Powered by phpBB® Forum Software © phpBB Group