Edit

Share via

DisplayFormat.ShrinkToFit property (Excel)

  • Article

Returns a value that indicates if Microsoft Excel automatically shrinks text to fit in the available column width of the associated Range object as it is displayed in the current user interface. Read-only.

Syntax

expression.ShrinkToFit

expression A variable that represents a DisplayFormat object.

Return value

Variant

Remarks

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

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.