r/GoogleAppsScript

Hi all,

I have a trigger running to center the cells of our spreadsheets, however it only centers the first sheet and not all. Is there a way to center all of the sheets instead of just the first one?

See what I have below. Thank you for the help!

function centerAllText() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getDataRange(); // Gets the range containing data
  range.setHorizontalAlignment("center");
  range.setVerticalAlignment("middle"); 
}function centerAllText() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getDataRange(); // Gets the range containing data
  range.setHorizontalAlignment("center");
  range.setVerticalAlignment("middle"); 
}