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

> ## Agent Instructions
> Automate.ax automations are TypeScript programs.
> Use Bun for installation and command examples.
> Use Automate.ax for the product name and automate.ax for the package, CLI, and domain.
> Treat documented public APIs as current; do not invent transitional or deprecated names.

# Delete banded range

> Remove ordinary alternating-color formatting while preserving Google Sheets values.

`googleSheets.deleteBandedRange()` removes an ordinary banded range and preserves every cell value in its range.

## Example

```ts theme={null}
import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Remove report banding", () => {
  onDashboardRun({ title: "Remove report banding" })

  googleSheets.deleteBandedRange({
    spreadsheet: "spreadsheet-id",
    bandedRangeId: 184302910,
  })
})
```

## Inputs

Provide `spreadsheet` and the integer `bandedRangeId`. You can obtain the ID from [`getSpreadsheet()`](/reference/integrations/google-sheets/actions/get-spreadsheet) or a banded-range action. Reference-only banded ranges can't use this action. Second argument `{ account }` selects the Google Account.

This action removes formatting and preserves values. In contrast, [`deleteTable()`](/reference/integrations/google-sheets/actions/delete-table) also deletes cell contents.

## Output

Returns the deleted banded range's former ID, zero-based range, and row or column colors.