Google电子表格超链接到特定工作表 [英] Google spreadsheet hyperlink to a specific sheet
问题描述
我想在另一个电子表格的超链接中打开Google电子表格的特定工作表。
我的主电子表格中有不同的链接,超链接到相同的从电子表格,但不同的表。
我知道超链接功能,但它不适用于特定工作表。
感谢您的帮助
您可以使用此自定义脚本(工具>脚本编辑器)用例如连接它自定义绘图(插入>绘图...>保存并关闭,然后右键单击新绘图>分配脚本...>goToSheet2)
function goToSheet2(){
goToSheet(Sheet2);
}
函数goToSheet(sheetName){
var sheet = SpreadsheetApp.getActive()。getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
更新: I would like to open a specific sheet of a Google spreadsheet from an Hyperlink in another spreadsheet. I have different link in my master spreadsheet, and every should have an hyperlink to the same slave spreadsheet but to different sheet. I know hyperlink function but it doesn't do to a specific sheet. Thanks for the help You can use this custom script (Tools > Script Editor) function and connect it with e.g. custom drawing (Insert > Drawing... > Save and Close, then right click on new drawing> Assign Script... > "goToSheet2") Update: 这篇关于Google电子表格超链接到特定工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
在最新版本中,您可以选择单元格并添加链接(插入>链接),并直接选择链接到特定工作表:
p> function goToSheet2() {
goToSheet("Sheet2");
}
function goToSheet(sheetName) {
var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
}
In the newest version you can select cell and add link (Insert > Link) and select link to specific sheet directly: