/** * Remove All Empty Columns & Rows in the Entire Spreadsheets */ function removeUnusedCells() { let ss = SpreadsheetApp.getActive(); let allsheets = ss.getSheets(); for (let s in allsheets){ let sheet = allsheets[s]; let maxColumns = sheet.getMaxColumns(); let lastColumn = sheet.getLastColumn() || 1; let maxRows = sheet.getMaxRows(); let lastRow = sheet.getLastRow() || 1; if (maxColumns-lastColumn != 0) sheet.deleteColumns(lastColumn+1, maxColumns-lastColumn); if (maxRows-lastRow != 0) sheet.deleteRows(lastRow+1, maxRows-lastRow); } }