CellFormat.ShrinkToFit property (Excel)

Returns or sets a Variant value that indicates if text automatically shrinks to fit in the available column width.

Syntax

expression.ShrinkToFit

expression A variable that represents a CellFormat object.

Remarks

This property returns True if text automatically shrinks to fit in the available column width, or it returns Null if this property isn't set to the same value for all cells in the specified range.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.