title: How to go to the bottom cells on google sheets on open for all Tabs
body: <p>I created the following script to run in Google sheets on open to be able to automatically go to the bottom row of the sheet.
  enter code here    </p>
  
  <pre><code>function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var mysheet = ss.getActiveSheet();
  
  var lastrow = mysheet.getLastRow();
  
  mysheet.setActiveCell(mysheet.getDataRange().offset(lastrow-1, 0, 1,         1));  
  };
  </code></pre>
  
  <p>This script does work for the active tab but not the additional tabs?</p>