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:
- Selection
- Current Sheet
- Spread Sheet
Use of Functionality:
- It will use to clear operations like the below options in sheets:
- Clear Values: It will clear values based on your Source selection
- Clear Dropdown: It will clear the Dropdown based on your Source selection
- Clear Formatting: It will clear Format based on your Source selection
- Clear Notes: It will clear notes based on your Source selection