Set Range Border Tint And Shade(range Border Tint And Shade) Set Horizontal Alignment(horizontal Alignment) A null value indicates that the entire range doesn't have a uniform wrap setting Specifies if Excel wraps the text in the object. See ExcelScript.VerticalAlignment for details. Represents the vertical alignment for the specified object. Note: This property is only intended to be set to true. Returns null if the range contains more than one column and the columns aren't all the same height. Returns true if the column width of the Range object equals the standard width of the sheet.

Specifies if the column width of the Range object equals the standard width of the sheet. Returns null if the range contains more than one row and the rows aren't all the same height. Returns true if the row height of the Range object equals the standard height of the sheet. If the orientation within a range are not uniform, then null will be returned.Дetermines if the row height of the Range object equals the standard height of the sheet. The text orientation should be an integer either from -90 to 90, or 180 for vertically-oriented text. The text orientation of all the cells within the range. Specifies if text automatically shrinks to fit in the available column width. If the row heights are not uniform, null will be returned. A null value indicates that the entire border collection doesn't have a uniform tintAndShade setting. The value is between -1 (darkest) and 1 (brightest), with 0 for the original color. Specifies a double that lightens or darkens a color for range borders. Returns the format protection object for a range. See ExcelScript.HorizontalAlignment for details.ДЄn integer from 0 to 250 that indicates the indent level. Represents the horizontal alignment for the specified object. Returns the font object defined on the overall range. Returns the fill object defined on the overall range. If the column widths are not uniform, null will be returned. Specifies the width of all colums within the range. Specifies if text is automatically indented when text alignment is set to equal distribution.Д¬ollection of border objects that apply to the overall range.

The indent value ranges from 0 to 250 and is measured in characters.Д¬hanges the width of the columns of the current range to achieve the best fit, based on the current data in the columns.Д¬hanges the height of the rows of the current range to achieve the best fit, based on the current data in the columns. In this article Methods adjust Indent(amount)ДЄdjusts the indentation of the range formatting.

A format object encapsulating the range's font, fill, borders, alignment, and other properties.

Excel shrink column width automatically