# 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

A cell or a collection of cells in a worksheet is called Range and the various operations executed on the cells in rows and columns is called Range Operations.
In DsExcel Java, the [getRange](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IWorksheet.html#getRange) method in the [IWorksheet](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IWorksheet.html) interface enables users to perform range operations.
Using DsExcel Java, users can handle the following range operations:

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

## See Also

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