> 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 a cell/range of an excel sheet.

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)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  A variable name that references the opened excel file handle.
* **Sheet Name** : [`String Argument`](/getting-started/rpa-studio/arguments.md#string)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  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)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  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.