# Delete Range

> `UiPath.Excel.Activities.ExcelDeleteRange`

`UiPath.Excel.Activities.ExcelDeleteRange`

Deletes a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the **ShiftCells** and **ShiftOption** property fields.

## Properties

#### Common

* **DisplayName** - The display name of the activity.

#### Input

* **Range** - The range you want to delete. This field supports only strings and String variables.
* **SheetName** - The name of the sheet you want to create the workbook from. This field supports only strings and String variables.

#### Misc

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

#### Options

* **ShiftCells** - If this box is cleared, only the cell data is deleted, leaving the formatting unmodified. If selected, cell formatting is shifted according to what is specified in the **ShiftOption** property. By default, this check box is cleared.
* **ShiftOption** - Specifies how to shift the cells in the deleted range. The available options are **ShiftUp**, **ShiftDown**, **EntireRow**, and **EntireColumn**.

## Example of Using the Delete Range Activity

To exemplify how to use this activity, we have built an automation project which deletes a range in an Excel workbook.

[Download example](https://www.uipath.com/hubfs/Documentation/WorkflowExamples/18.3%20Examples/Excel/Delete%20Range.zip)