> ## 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.

# Clear range formatting

> Clear all or selected cell formatting without changing Google Sheets values.

`googleSheets.clearRangeFormatting()` removes formatting from a grid range or native-table section while preserving cell values.

## Example

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

export default automation("Reset order body styles", () => {
  onDashboardRun({ title: "Reset order body styles" })

  googleSheets.clearRangeFormatting({
    spreadsheet: "spreadsheet-id",
    range: { table: "OrdersTable", section: "body" },
    properties: ["backgroundColor", "borders", "text.bold"],
  })
})
```

## Inputs

Provide `spreadsheet` and `range`. A grid range takes `sheet` plus optional one-based inclusive row and column bounds. A table target takes `table` and optional `section`: `all`, `header`, `body`, or `footer`.

Omit `properties` to clear all user-entered cell formatting. Otherwise provide one or more of `backgroundColor`, `borders`, `horizontalAlignment`, `hyperlinkDisplay`, `numberFormat`, `padding`, `rotation`, `text`, `text.bold`, `text.color`, `text.family`, `text.italic`, `text.link`, `text.size`, `text.strikethrough`, `text.underline`, `textDirection`, `verticalAlignment`, or `wrap`. Clearing `text` clears every text-format property. Use a `text.*` value for a narrower reset.

This action doesn't remove [conditional-format rules](/reference/integrations/google-sheets/actions/delete-conditional-format-rule), [ordinary banding](/reference/integrations/google-sheets/actions/delete-banded-range), or [native-table styling](/reference/integrations/google-sheets/actions/update-table). Those separate layers can still make cleared cells look formatted.

Second argument `{ account }` selects the Google Account. All action inputs accept compatible signals.

## Output

Returns the resolved zero-based, end-exclusive grid range with numeric `sheetId`.