> For the complete documentation index, see [llms.txt](https://docs.visualyze.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.visualyze.ai/rpa-studio/microsoft-office/excel/range/delete-range.md).

# Delete Cell/Range

Delete the specified cell/range of the excel sheet and shift cells if required.

{% hint style="info" %}
This activity can only be used after the [Open Excel File activity.](/rpa-studio/microsoft-office/excel/open-excel-file.md)
{% endhint %}

### Input

* **Input** : [`ExcelHandle Variable`](/getting-started/rpa-studio/variables.md#excelhandle)![](/files/-MVREnwPf_D3-qJvjjYd)\
  A variable name that references the opened excel file handle.
* **Sheet Name** : [`String Argument`](/getting-started/rpa-studio/arguments.md#string)![](/files/-MVREnwPf_D3-qJvjjYd)\
  The name of the sheet in which the cell/range is to be deleted.

### Options

* **Range** : [`String Argument`](/getting-started/rpa-studio/arguments.md#string)![](/files/-MVREnwPf_D3-qJvjjYd)\
  The cell/range of the excel sheet is to be deleted.

{% hint style="info" %}
The range is specified in `A1:E10` or `A1` format. `A1:E10` will select all cells of the first five columns from row 1 to 10. `A1` will select the first cell from the first row.
{% endhint %}

* **Shift Cells** :
  * `True` - Cells will be shifted according to the Shift Option.
  * `False` - Delete only cell data and leave formatting unchanged. `Default`
* **Shift Option** : `Optional`

  The format in which cells should be shifted to fill the deleted cell/range.
* `ShiftUp` - Cells will be shifted up after deletion in the given range. `Default`
* `ShiftLeft` - Cells will be shifted left after deletion in the given range.
* `EntireColumn` - Delete the entire column and shift left.
* `EntireRow` - Delete the entire row and shift up.