# Clear Range

> `UiPath.GSuite.Activities.ClearRange`

`UiPath.GSuite.Activities.ClearRange`

## Description

Clears the values in a specified range of cells. Only clears values; all other settings are kept.

### Scopes

This activity requires the following scopes:

* https://www.googleapis.com/auth/drive

OR

* https://www.googleapis.com/auth/spreadsheets

## Project compatibility

Windows - Legacy | Windows

## Configuration

#### In the body of the activity

* **Sheet** -The sheet in the document from which the range will be cleared. The default value is **Sheet1**. This property supports `String` variables and string formatted values.
* **Range** - Specifies the range of cells that you want to clear. This property supports `String` variables and string formatted values (enter your range in A1-style notation). The default value is "A1:B2".

  + For example, if you have data in cells A1:C4, and you enter "A1:B3" as your **Range**, the data in cells A1:B3 are cleared and the data in cells A4, B4, and C1:C4 remains.
  + For example, if you have data in cells A1:C4, and you enter A1:B3 as your **Range**, the data in cells A1:B3 are cleared and the data in cells A4, B4, and C1:C4 remains.

#### Properties panel

**Common**

* **ContinueOnError** - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
* **DisplayName** - The display name of the activity. This property supports `String` variables and string formatted values.

**Input**

* **Range** - See **Range** in the body of the activity.
* **SheetName** - The name of the sheet that you want to make changes to. This property supports `String` variables and string formatted values. The default value is "Sheet1".
* **Spreadsheet** - A reference to a Google Spreadsheet where the change will be made. Typically obtained via the [Use Google Spreadsheet](https://docs.uipath.com/activities/other/latest/productivity/google-sheets-application-scope) activity. This property supports `IGoogleSheetTarget` variables.
* **SpreadsheetID** - The ID of the spreadsheet where you want to add the new sheet. This property supports String variables and string formatted values. When entering your value, use the exact ID, or the output property variable from a previous [Find Files And Folders](https://docs.uipath.com/activities/other/latest/productivity/gsuite-find-files) or [Copy File](https://docs.uipath.com/activities/other/latest/productivity/gsuite-copy-drive-file) activity.

**Misc**

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.