# Range Operations

DsExcel provides numerous operations to perform on a range such as access a range, cut or copy cell ranges, insert or delete cell ranges, and more.

## Content

Range refers to a cell or a collection of cells and range operations are the operations performed on those cell collection using single line of code. The [Range](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IWorksheet.Range.html) property of [IWorksheet](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IWorksheet.html) allows you to execute multiple operations on cells,rows or columns.
The operations that can be handled using Range property are as follows:

* [Access a Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/AccessaRange)
* [Get Intersection, Union and Offset Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/get-intersection-offset-union)
* [Access Areas in a Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/AccessAreasinaRange)
* [Get Special Cell Ranges](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/get-special-cell-ranges)
* [Access Cells, Rows and Columns in a Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/AccessCellsRowsandColumns)
* [Get Address of Cell Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/get-address-of-cell-range)
* [Cut or Copy Cell Ranges](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/CutOrCopyCellRanges)
* [Cut or Copy Shape, Slicer, Chart and Picture](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/CutorCopyShapeSlicerChartandPicture)
* [Paste or Skip Data in Hidden Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/paste-ignore-data-hidden-range)
* [Find and Replace Data](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/FindandReplaceData)
* [Get Row and Column Count](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/GetRowandColumnCount)
* [Hide Rows and Columns](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/HideRowsColumns)
* [Insert And Delete Cell Ranges](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/InsertAndDeleteCellRanges)
* [Insert and Delete Rows and Columns](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/InsertAndDeleteRowsAndColumns)
* [Merge Cells](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/MergeCells)
* [Auto Merge Cells](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/AutoMergeCells)
* [Protect Cell Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/ProtectCellRange)
* [Set Values to a Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/SetValuestoaRange)
* [Set Custom Objects to a Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/set-custom-objects-to-range)
* [Set Row Height and Column Width](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/SetRowHeightandColumnWidth)
* [Auto Fit Row Height and Column Width](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/AutoFitRowHeightandColumnWidth)
* [Work with Used Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/WorkWithUsedRange)
* [Measure Digital Width](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/measure-digital-width)
* [Set Default Values for Cell Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/SetDefaultValuesforCellRange)
* [Set Cell Background Image for Cell Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/SetCellBackgroundImageforCellRange)
* [Ignore Errors in Cell Range](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/IgnoreErrorsinCellRange)
* [Picture in Cell](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/picture-in-cell)

## See Also

[Worksheet](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet)
[Customize Worksheets](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/CustomizeWorksheets)