Determines if text automatically shrinks to fit in the available column width.

[Visual Basic]
Property ShrinkToFit As Boolean
[C#]
bool ShrinkToFit { get; set; }
[C++]
__property bool get_ShrinkToFit();
__property void set_ShrinkToFit(bool );
[JScript]
function get ShrinkToFit() : bool
function set ShrinkToFit(bool);

Property Value

true if text automatically shrinks to fit in the available column width; otherwise, false.

Example

This example sets ShrinkToFit property for the cells B5:F30 on sheet one.

[C#]
 IRange r = book.Worksheets[1].Range["B5:F30"]; 
 r.ShrinkToFit = true;

[Visual Basic]
 Dim r As IRange = book.Worksheets(1).Range("B5:F30")
 r.ShrinkToFit = True

[C++]
 IRange* r = book->Worksheets->Item[1]->Range->Item[S"B5:F30"]; 
 r->ShrinkToFit = true;

See Also

IRange Interface | NativeExcel Namespace

---