> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Delete Range Cells

Remove the specified cells from the worksheet and shift remaining cells to fill the gap.

**Least privileged** Microsoft Graph permissions to access the action via **application**: `Files.ReadWrite`.

**Note**: Using the delegated (OAuth) connection type will only allow to insert the connected user's ID.

<Note>
  External Documentation

  To learn more, visit the [Microsoft Excel documentation](https://learn.microsoft.com/en-us/graph/api/range-delete?view=graph-rest-1.0\&tabs=http).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter            | Description                                                                                                                                                                         |
  | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Address              | The range of cells to delete using Excel notation.<br /><br />For example: `A1:C10` for cells A1 through C10.                                                                       |
  | Drive ID             | The unique identifier of the drive (OneDrive or SharePoint document library) that contains your Excel file.                                                                         |
  | Item ID              | The ID of the Excel file to interact with.                                                                                                                                          |
  | Shift                | Specify the direction to move remaining cells.                                                                                                                                      |
  | Site ID              | The ID of the SharePoint site containing your Excel file.                                                                                                                           |
  | Source               | Choose whether to pull your Excel file from SharePoint or OneDrive.                                                                                                                 |
  | User ID              | The User ID of the user whose OneDrive contains the Excel file.<br /><br />**Note**: Using the delegated (OAuth) connection type will only allow to insert the connected user's ID. |
  | Worksheet ID Or Name | The ID or display name of the worksheet to interact with.                                                                                                                           |
</div>

## Advanced Parameters

<div className="integrations-table">
  | Parameter           | Description                                                                                                                                                                                                                                                                                                                                                                                                                                        |
  | ------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Workbook Session ID | The session ID for maintaining context across multiple operations. Using a session improves performance and allows you to control whether changes are saved. If not provided, each operation runs independently which is less efficient.<br /><br />For more information about the `Workbook Session ID`, refer to [Microsoft's documentation](https://learn.microsoft.com/en-us/graph/api/workbook-createsession?view=graph-rest-1.0\&tabs=http). |
</div>

## Workflow Library Example

[Delete Range Cells with Microsoft Excel and Send Results Via Email](https://library.blinkops.com/workflows/delete-range-cells-with-microsoft-excel-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/delete-range-cells-with-microsoft-excel-and-send-results-via-email/canvas" />
</div>