Smart Way to Clear Data In Google Sheets

Many times we need to clear formatting/notes/dropdowns and values in google sheets.
This can be done by clear formatting/delete notes/delete data validation. But wait !! what if you want to clear in current sheets/spreadsheet in a few clicks.

CLICK HERE to Install the addon.

How to Open Functionality:

• First of all, open the Google sheet then go to Extension > Sutra Tools > Sheet Operations > Clear like the below screenshot:

• After clicking on Clear it Shows below sidebar:

• First of all this functionality  work in 3 ways:

1. Selection
2. Current Sheet
3. Spread Sheet

Use of Functionality:

• It will use to clear operations like the below options in sheets:

1. Clear Values: It will clear  values based on your Source selection
2. Clear Dropdown: It will clear the Dropdown based on your Source selection
3. Clear Formatting: It will clear Format based on your Source selection
4. Clear Notes: It will clear notes based on your Source selection