{"id":2324,"date":"2023-07-22T18:44:02","date_gmt":"2023-07-22T18:44:02","guid":{"rendered":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/"},"modified":"2023-07-22T18:44:02","modified_gmt":"2023-07-22T18:44:02","slug":"tautan-google-sheet-ke-tab-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/","title":{"rendered":"Cara menautkan ke tab lain di google spreadsheet (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat tautan antara satu tab di spreadsheet Google Spreadsheet dan tab lain di spreadsheet yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi <strong>HYPERLINK()<\/strong> dan contoh berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: tautan ke tab lain di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki spreadsheet berikut dengan empat tab yang berisi berbagai informasi tentang tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21129 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lien1.png\" alt=\"\" width=\"504\" height=\"514\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menautkan ke tab <strong>Poin<\/strong> , pertama-tama klik pada tab Poin, lalu salin URL ke bagian atas browser Anda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda akan melihat bahwa URL untuk tab <strong>Poin<\/strong> akan berbeda dengan URL untuk tab <strong>Tim<\/strong> . Misalnya, URL tab <strong>Tim<\/strong> diakhiri dengan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\">#gid=0<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sebaliknya, URL tab <strong>Poin<\/strong> diakhiri dengan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\">#gid=788433911<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian bisa mengetikkan rumus berikut di sel B2 untuk ditautkan ke tab <strong>Poin<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">HYPERLINK<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" string \" dir=\"auto\">\"https:\/\/docs.google.com\/spreadsheets\/d\/1jTA\/edit#gid=788433911\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"Points\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Setelah selesai, hyperlink akan muncul di spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-21131\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lien2.png\" alt=\"tautan ke tab lain di Google Spreadsheet\" width=\"525\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ketika kita mengklik hyperlink ini, secara otomatis kita akan dibawa ke tab <strong>Poin<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21132 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lien3.png\" alt=\"\" width=\"581\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menggunakan proses yang sama untuk menautkan ke tab <strong>Bantuan<\/strong> dan <strong>Pentalan<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menanyakan beberapa lembar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-di-beberapa-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menambahkan beberapa lembar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat tautan antara satu tab di spreadsheet Google Spreadsheet dan tab lain di spreadsheet yang sama. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi HYPERLINK() dan contoh berikut menunjukkan cara melakukannya. Contoh: tautan ke tab lain di Google Spreadsheet Misalkan kita memiliki spreadsheet berikut dengan empat tab yang berisi berbagai informasi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menautkan ke Tab Lain di Google Spreadsheet (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menautkan ke tab lain di Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menautkan ke Tab Lain di Google Spreadsheet (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menautkan ke tab lain di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T18:44:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lien1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/\",\"name\":\"Cara Menautkan ke Tab Lain di Google Spreadsheet (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T18:44:02+00:00\",\"dateModified\":\"2023-07-22T18:44:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menautkan ke tab lain di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menautkan ke tab lain di google spreadsheet (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menautkan ke Tab Lain di Google Spreadsheet (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menautkan ke tab lain di Google Sheets, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menautkan ke Tab Lain di Google Spreadsheet (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menautkan ke tab lain di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-22T18:44:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lien1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/","url":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/","name":"Cara Menautkan ke Tab Lain di Google Spreadsheet (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T18:44:02+00:00","dateModified":"2023-07-22T18:44:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menautkan ke tab lain di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tautan-google-sheet-ke-tab-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menautkan ke tab lain di google spreadsheet (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2324"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2324"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2324\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}