var sheet = ss.getSheetByName("Questionário DQSA"); var range = sheet.getRange("F1"); range.deleteCells(SpreadsheetApp.Dimension.COLUMNS);//F2 becomes the new F1