| | Name | Description |
|---|
 | AllowEdit | Gets a value indicating whether the range can be edited on a protected worksheet. |
| Areas | Gets an IAreas collection that represents all the ranges in a multiple-area selection. |
| Borders | Gets the IBorders object that represents the borders of the specified object. |
| Cells | Gets a IRange object that represents the cells in the specified range. |
| CellType | Gets or sets the cell type for cells in this IRange. |
| Column | Gets the zero based column number of the first column of this IRange. |
| Column2 | Gets the zero based column number of the last column of this IRange. |
| ColumnCount | Gets the number of columns in this IRange. |
| Columns | Gets a new instance of IRange which represents all columns belong to this IRange. |
| ColumnWidth | Gets or sets the width of the column. |
| Comment | Gets a Comment object that represents the comment associated with the cell in the upper-left corner of the range. |
| CommentThreaded | Gets an ICommentThreaded object that represents the threaded comment associated with the cell in the upper-left corner of the range. |
| Count | Get an integer value that represents the number of cells in the range. |
| CurrentArray | Gets an IRange object that represents the entire array if the specified cell is part of an array. |
| CurrentRegion | Gets an IRange object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. |
| Dependents | Returns a IRange object that represents the range containing all the dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. |
| DirectDependents | Returns a IRange object that represents the range containing all the direct dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. |
| DirectPrecedents | Returns a IRange object that represents the range containing all the direct precedents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. |
| DisplayFormat | Gets a DisplayFormat object that represents the display settings for the specified range. |
| EntireColumn | Gets a IRange object that represents the entire column (or columns) that contains the specified range. |
| EntireRow | Gets a IRange object that represents the entire row (or rows) that contains the specified range. |
| Font | Gets the IFont object that represents the font of the specified object. |
| FormatConditions | Gets all format conditions of this IRange. |
| FormattedValue | Gets or sets the cell value(s). |
| Formula | Gets or sets the formula, which will implicitly intersect as required when set, for this IRange. |
| Formula2 | Gets or sets the formula for this IRange. |
| Formula2R1C1 | Gets or sets the formula using R1C1-style notation for this IRange. |
| FormulaArray | Gets or sets the array formula for this IRange. |
| FormulaR1C1 | Gets or sets the formula using R1C1-style notation which will implicitly intersect as required when set, for this IRange. |
| HasArray | Gets a value indicating whether the specified cell is part of an array formula. |
| HasFormula | Gets a value indicating whether all cells in the range contain formulas. |
| HasRichDataType | true if all cells in the range contain a Rich data type. false if none of the cells in the range contains a Rich data type; otherwise, null. |
| HasSpill | Gets a value indicating whether all cells are part of a spilled range. |
| Height | Gets a System.Int64 value that represents the height, in pixels, of the range. |
| Hidden | Gets or sets a value indicating whether this IRange is hidden. |
| HorizontalAlignment | Gets or sets the horizontal alignment. |
| Hyperlinks | Gets an IHyperlinks collection that represents the hyperlinks for the range. |
| IndentLevel | Gets or sets the indent level. |
| Interior | Gets the IInterior object that represents the interior of the specified object. |
| Item | Overloaded. Gets the IRange with the specified reference. |
| Left | Returns a System.Int64 value that represents the distance, in pixels, from the left edge of column A to the left edge of the range. |
| Locked | Gets or sets a value indicating whether this IRange is locked. |
| MergeArea | Returns a Range object that represents the merged range containing the specified cell. If the specified cell isn't in a merged range, this property returns the specified cell. |
| MergeCells | Gets or sets a value indicating whether this range contains merged cells. |
| MergePolicy | Gets or sets a MergePolicy value indicating whether to automatically merge adjacent identical cells. |
| Next | Returns an IRange object that represents the next cell. |
| NumberFormat | Gets or sets the number format of current cell. |
| Orientation | Gets or sets the text orientation. |
| OutlineLevel | Gets or sets the current outline level of the specified row or column. |
| PageBreak | Gets or sets the location of a page break. |
| Precedents | Returns an IRange object that represents all the precedents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one precedent. |
| Previous | Returns an IRange object that represents the previous cell. |
| Resizable | Gets or sets whether the range is resizable. |
| Row | Gets the zero based row number of the first row of this IRange. |
| Row2 | Gets the zero based row number of the last row of this IRange. |
| RowCount | Gets the number of rows in this IRange. |
| RowHeight | Gets or sets the height of the row. |
| Rows | Gets a new instance of IRange which represents all rows belong to this IRange. |
| ShowDetail | true if the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. |
| ShrinkToFit | Gets or sets a value indicating whether text automatically shrinks to fit in the available column width. |
| SparklineGroups | Gets an ISparklineGroups object that represents an existing group of sparklines from the specified range. |
| Style | Gets or sets the style for the cell. |
| Summary | Gets a value indicating whether the range is an outlining summary row or column. |
| Table | Returns an ITable object for the IRange object. |
| Text | Gets or sets the text for the cell. |
| Top | Gets a System.Int64 value that represents the distance, in pixels, from the top edge of row 1 to the top edge of the range. |
| UseStandardHeight | Gets or sets a boolean value indicating whether the row height of the IRange object equals the standard height of the sheet. Returns null if the range contains more than one row and the rows aren't all the same height. |
| UseStandardWidth | Gets or sets a boolean value indicating whether the column width of the IRange object equals the standard width of the sheet. Returns null if the range contains more than one column and the columns aren't all the same width. |
| Validation | Gets an instance of IValidation which may be used to get and set validation properties of the cells represented by this IRange. |
| Value | Gets or sets the cell value. |
| VerticalAlignment | Gets or sets the vertical alignment. |
| Width | Gets a System.Int64 value that represents the width, in pixels, of the range. |
| Worksheet | Gets a Worksheet object that represents the worksheet containing the specified range. |
| WrapText | Gets or sets a value indicating whether Spread wraps the text in the object. |
