다음을 통해 공유

Range.ShrinkToFit Property (Excel)

  • 아티클

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

Syntax

식 .ShrinkToFit

식 A variable that represents a Range object.

Remarks

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

Example

This example causes text in row one to automatically shrink to fit in the available column width.

Rows(1).ShrinkToFit = True

참고 항목

개념

Range Object

Range Object Members