Let’s create a button to go to the left hand most page. Please select one of the right hand pages or push the + sign in the lower left to create one.
Here’s the script:
function gotoMostLeftPage() {
var ss=SpreadsheetApp.getActive();
ss.setActiveSheet(ss.getSheets()[0]);
}
Now we need a button:
We can use insert/Drawing to draw an image of our drawing.
In this case I’m using a basic shape. You can add text if you like.
Now just save and close.
Drag the button to where you want it and click on the three buttons in the upper right.
Select Assign script.
Copy the script name.
Paste it into the dialog and click ok.
Try clicking on the button and it should take you to the left most page unless you are already there.