Clear ranges with the Script:
all settings in the sheet
clear multiple ranges in one click
clear the range to the end of the page
clear ranges from multiple spreadsheets
To use the script, please, create your copy of the file:
https://docs.google.com/spreadsheets/...
The file contains the script. Go to "Tools → Script Editor" to see and test it.
Tags:
Google-Sheets, Google-Apps-Script, Automation