Google-sheets – Jump to the end of data in all sheets, not just the current one

google sheetsgoogle-apps-scriptkeyboard shortcuts

I have a Google Spreadsheet with 10 sheets. All of them with ~1000 rows.

I need to go to the end on every tab, not just first sheet.

How can I do that?

Imagine 100 sheets (tabs) in one spreadsheet. All 1000 lines or more. Every time I go to new sheet(tab) I have to scroll down to the end of it. What can be done to avoid scrolling and getting me to either last edited place (in every sheet) or end of data range.
I'm using Windows 10 or Windows 8, US standard keyboard.

Best Answer

I needed something like that:

function onOpen() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var entries = [{name:"goto_last", functionName:"goto_last"}];
  sheet.addMenu("Scripts", entries);

function goto_last() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var mysheet = ss.getActiveSheet();

  var lastrow = mysheet.getLastRow();

  mysheet.setActiveCell(mysheet.getDataRange().offset(lastrow-1, 0, 1, 1));

thank you for the answers!