| Name | Description | |
|---|---|---|
 | Activate | Activates a single cell, which must be inside the current selection. |
| AddComment | Adds comments to the current IRange. |
| AddCommentThreaded | Adds a threaded comment to the current IRange. |
| AutoFilter | Filters a list using the AutoFilter. |
| AutoFit | Overloaded. Changes the width of the columns in the range or the height of the rows in the range to achieve the best fit. |
| Calculate | Calculates formulas of the range as needed. |
| Characters | Returns a ITextRun object that represents a range of characters within the cell text, this method can only be called when the value of cell is a string, or else System.InvalidOperationException is thrown. |
| Clear | Clears formulas, values, and all formatting from the current IRange. |
| ClearComments | Clears the comments from the current IRange |
| ClearCommentsThreaded | Clears the threaded comment from the current IRange |
| ClearContents | Clears formulas and values from the current IRange. |
| ClearFormats | Clears all formatting from the current IRange. |
| ClearHyperlinks | Clears all hyperLinks from the current IRange. |
| ClearOutline | Clears the outline for the specified range. |
| Copy | Overloaded. Copies the range to the specified range. |
| Cut | Cuts the range to the specified range. |
| Delete | Deletes a cell or a range of cells from the worksheet and shifts other cells to replace deleted cells. Specifies which way to shift the cells. |
| Dirty | Designates all the formulas of the range to be recalculated when the next calculation occurs. |
| Find | Finds specific information in a range. |
| FromJson | Generates the range data from the JSON string. |
| GenerateGetPivotDataFunction | Generate the corresponding function "GETPIVOTDATA" for the cells in the pivot table. |
| GetAddress | Returns a System.String value that represents the range reference. If all parameters are omitted, the return value is equal to the Address property. |
| GetDependents | Overloaded. Gets the dependent ranges of the left top cell of the range. |
| GetPrecedents | Overloaded. Gets the precedent ranges of the left top cell of the range. |
| GetUsedRange | Gets an IRange representing the used range in the current range. |
| Group | Increments the OutlineLevel of the specified rows or columns. |
| Insert | Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space. Specifies which way to shift the cells. |
| Intersect | Overloaded. Returns an IRange object that represents the intersection of two ranges. If range2 is from a different worksheet, an exception is thrown. |
| Merge | Merges the cells in the represented range into a single merged cell. |
| Offset | Returns an IRange object that represents the offset of this range. |
| RemoveSubtotal | Removes subtotals from a list. |
| Replace | Search in formulas and replace. Using this method doesn't change either the selection or the active cell. |
| Select | Selects the object. |
| Sort | Overloaded. Sorts the cells represented by this range according to the specified options. |
| SpecialCells | Gets a IRange object that represents all the cells that match the specified type and value. |
| Subtotal | Creates subtotals for the range. |
| ToImage | Overloaded. Saves the range to the specified image file. |
| ToJson | Generates a JSON string from the range. |
| Ungroup | Decrements the OutlineLevel of the specified rows or columns. |
| Union | Overloaded. Returns an IRange object that represents the union of two ranges. If range2 is from a different worksheet, an exception is thrown. |
| UnMerge | Converts merged cells in the represented range to normal cells. |