-
-
Save tamirko/da69818c4ced9b71cff4ce236b9dd4bd to your computer and use it in GitHub Desktop.
function onOpen() | |
{ | |
var menuEntries = [{name: "Go to", functionName: "goToCell"}]; | |
SpreadsheetApp.getActiveSpreadsheet().addMenu("MyUtils", menuEntries); | |
} | |
function goToCell() | |
{ | |
var strRange = Browser.inputBox("Insert the required cell (e.g.: B351):", Browser.Buttons.OK_CANCEL); | |
if(strRange != "cancel") | |
{ | |
try | |
{ | |
SpreadsheetApp.getActiveSheet().getRange(strRange).activate(); | |
} | |
catch(e) {Browser.msgBox(e.message);} | |
} | |
} |
My Youtube channel: https://www.youtube.com/user/tamirkoremu
I need help to be able to jump to given row from stand-alone Google Apps Script or by visiting a link without page refresh like @seanbreckenridge's solution. I've got a chrome extension that injects a panel on top of the sheet and the extension can access the sheet through a standalone google apps script, now I want to jump to the variable row by clicking a button on that panel.
My problem is solved by adding a # to the @seanbreckenridge's URL to avoid page refresh.
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0&range=A30#
Just adding some input, If we have to hyperlink the cell from a sheet within same workbook, we don't have to write complete link as mentioned above, Let me suggest two easy options here;
- wherever you want to create a link, just type =HYPERLINK("#rangeid=sheet ID","sheet name"), writing Sheet Name here means that you want this name to be shown in the Cell
or - just right click on any cell, click on Insert Link, and click on the sheet where you want the link, it will work
@mordechaibod
You can go to a specific cell using a hyperlink by adding
&range={cell}
after#gid={Sheet_ID}
:https://docs.google.com/spreadsheets/d/{Spreadsheet_ID}/edit#gid={Sheet_ID}&range=A100
would go to the cell A100 on the spreadsheet.For Example: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0&range=A30
SpreadSheet ID distinguishes your spreadsheet, and Sheet ID's differentiate pages. More info on that here.