---
description: >-
  Clear the content or formatting for a Cell or all Cells in a Range or
  Worksheet
---

# Clear

## Description

Clear the content or formatting for a Cell or all Cells in a Range or Worksheet

{% tabs %}
{% tab title="Preview" %}
![](https://2501927618-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe08Uu2w6ybaOmfvcxkKf%2Fuploads%2FDdUOWxvjUtDggBnkCkru%2FFormat_Clear.png?alt=media\&token=211613ee-1a1a-44e0-a19b-33c7b36e0e70)
{% endtab %}

{% tab title="Location" %}
**Name** | Clear

**Nickname** | Clear

**Tab** | ExcelPlus

**Panel** | Format

**Division** | 1
{% endtab %}

{% tab title="Inputs" %}
**Obj** | **Object** (_object_) | Clear all values

**V** | **Clear Values** (_bool_) | A Cell, Range, Worksheet, or Workbook Object

**F** | **Clear Formatting** (_bool_) | A Cell, Range, Worksheet, or Workbook Obj

**C** | **Clear Conditions** (_bool_) | A Cell, Range, Worksheet, or Workbook Obj
{% endtab %}

{% tab title="Outputs" %}
**Obj** | **Object** (_object_) | A Cell, Range, Worksheet, or Workbook Object
{% endtab %}

{% tab title="Mode" %}
_none_
{% endtab %}
{% endtabs %}

## Usage
