Creating a reset button on Google Sheets

Link to Alice Keeler's Template Tab Script: https://alicekeeler.com/2015/01/02/google-sheets-copy-a-template-for-each-student/

Reset Button Script (copy everything below this line):
// This section adds the top menu
function onOpen() {
SpreadsheetApp.getUi().createMenu('Reset')
.addItem("Formulas Only", "ResetFormulas")
.addItem("Entire Page", "ResetPage")
.addToUi()
}

// This section makes a button to reset the whole page copies the entire page
function ResetPage() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName('template'); // Enter tab name of what you’re copying from
sheet.getRange('A1:AZ192').copyTo(ss.getRange('A1:AZ192')) //enter entire tab range

}
// This section copies only the cells you specify
function ResetFormulas() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName('template'); // Enter tab name here of what you’re copying from
//Header
sheet.getRange('A2:AK2').copyTo(ss.getRange('A2:AK2')) //first range you’re copying
sheet.getRange('Q3:AK3').copyTo(ss.getRange('Q3:AK3')) //next range
sheet.getRange('A4:AK4').copyTo(ss.getRange('A4:AK4')) //etc
sheet.getRange('A6:AZ9').copyTo(ss.getRange('A6:AZ9')) //you get it

}

Скачать видео