# Insert And Delete Cell Ranges

DsExcel allows you to insert and delete a cell or a range of cells while working with spreadsheets. Learn more in DsExcel docs.

## Content

DsExcel enables you to insert and delete a cell or a range of cells in order to help customization of worksheets as per your requirements.

## Insert cell range

DsExcel allows you to add a cell or a range of cells in a worksheets by calling the [Insert](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Insert.html) method of [IRange](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.html). To add a cell or a range of cells, specify the cell range, for example **A3** for single cell or **A3:A5** for a range of cells.
DsExcel provides following different options to insert a cell or a range of cells.

| **Method** | **Description** |
| ------ | ----------- |
| Insert | This method automatically inserts a cell or a range of cells. |
| Insert(InsertShiftDirection.Down) | This method inserts the range of cells and shifts the existing range of cells in downward direction. |
| Insert(InsertShiftDirection.Right) | This method insert the range of cells and shifts the existing range of cells to the right. |

Refer to the following example code to see how you can insert a single cell and a cell range in the worksheet.

```csharp
//Insert the range of cell
worksheet.Range["A3"].Insert();

// Insert the range of cells
worksheet.Range["A3:A5"].Insert();
```

Refer to the following example code to see how you can insert cell range in a worksheet while specifying a direction to shift the existing cells in required direction.

```csharp
//Insert the range of cells in desired direction
worksheet.Range["A3:B10"].Insert(InsertShiftDirection.Down);
worksheet.Range["A5:C5"].Insert(InsertShiftDirection.Right);
```

## Delete cell range

DsExcel allow you to delete a cell or a range of cells in the worksheets by calling [Delete](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Delete.html) method of [IRange](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.html). To remove a cell or a range of cells, specify the cell range, for example **B4** for a single cell or **B4:C4** for a range of cells.
DsExcel provide following different options to delete a cell or range of cells.

| **Method** | **Description** |
| ------ | ----------- |
| Delete | This method automatically deletes a cell or the range of cells. |
| Delete(DeleteShiftDirection.Left) | This method deletes the range of cells and moves the existing range of cells to the left. |
| Delete(DeleteShiftDirection.Up) | This method delete the range of cells and move the existing range of cells in upward direction. |

Refer to the following example code to see how you can delete single cell or a cell range in a worksheet.

```csharp
//Delete the range of cell
worksheet.Range["B4"].Delete();

// Delete the range of cells
worksheet.Range["B4:C4"].Delete();
```

Refer to the following example code to see how you can delete a single cell or a range of cells in a worksheet while specifying a direction to shift the existing cells in required direction.

```csharp
//Delete the range of cells from desired direction
worksheet.Range["B3:C8"].Delete(DeleteShiftDirection.Left);
worksheet.Range["B5:D5"].Delete(DeleteShiftDirection.Up);
```

## See Also

[Cut or Copy Cell Ranges](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/CutOrCopyCellRanges)