{"id":1692,"date":"2023-11-11T11:35:43","date_gmt":"2023-11-11T11:35:43","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/"},"modified":"2023-12-06T06:13:38","modified_gmt":"2023-12-06T06:13:38","slug":"hyperlink-dinamis-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/","title":{"rendered":"Bagaimana cara membuat hyperlink dinamis di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3330941632\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk membuat hyperlink dinamis di mana Anda bisa mengubah tautan yang Anda tentukan, Anda perlu menggunakan fungsi HYPERLINK Excel. Fungsi ini memungkinkan Anda menentukan link ke alamat web atau sel di buku kerja.<\/p><p> Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk ini.<\/p><h2 class=\"wp-block-heading\"> Tuliskan rumus untuk membuat hyperlink dinamis (alamat web)<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini untuk ini.<\/p><ol type=\"1\"><li> Pertama masukkan fungsi HYPERLINK dalam sel.<\/li><li> Setelah itu, pada argumen pertama, rujuk ke sel tempat Anda akan memperbarui alamat hyperlink, misalkan sel B1.<\/li><li> Kemudian, pada argumen kedua, masukkan nama ramah untuk tautan ke caranya di tautan tersebut.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13351\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png\" alt=\"formula-untuk-membuat-hyperlink-dinamis\" width=\"576\" height=\"253\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png 1138w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques-300x132.png 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques-1024x449.png 1024w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques-768x337.png 768w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=HYPERLINK(B1,\"Hello\")<\/code><\/pre><p> Di sel B1 kami memiliki daftar drop-down untuk mengubah alamat web. Dan saat Anda mengubah alamat link di sel B1, link di rumusnya juga akan berubah.<\/p><h2 class=\"wp-block-heading\"> Buat hyperlink dinamis untuk alamat sel<\/h2><p> Demikian pula, Anda bisa membuat hyperlink dinamis untuk sel di buku kerja. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80174\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-hyperlien-dynamique-pour-une-adresse-cellulaire.png\" sizes=\"auto, \" srcset=\"\" alt=\"hyperlink dinamis untuk alamat sel\" width=\"620\" height=\"212\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=HYPERLINK(\"#\"&amp;B1,\"Hello\")<\/code><\/pre><p> Pada rumus di atas, kita telah menggunakan &#8216;#&#8217; dengan kombinasi referensi sel sel B1. Sekarang, segera setelah Anda mengubah alamat sel di sel B1, tautan di rumusnya pun berubah. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/lien-hypertexte-dynamique.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/baris-baru-di-sel\/\">Tambahkan baris baru ke sel di Excel (jeda baris)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/angka-nol-di-depan\/\">Tambahkan angka nol di depan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-dengan-koma\/\">Gabungkan (gabungkan) sel dengan koma di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyatukan-sejumlah-sel\/\">Menggabungkan (menggabungkan) sejumlah sel di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-jeda-baris\/\">Gabungkan dengan jeda baris di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1692","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara membuat hyperlink dinamis di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hyperlink dinamis dalam sel. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membuat hyperlink dinamis di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hyperlink dinamis dalam sel. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/\",\"name\":\"\u25b7 Bagaimana cara membuat hyperlink dinamis di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png\",\"datePublished\":\"2023-11-11T11:35:43+00:00\",\"dateModified\":\"2023-12-06T06:13:38+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hyperlink dinamis dalam sel. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat hyperlink dinamis di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara membuat hyperlink dinamis di Excel?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hyperlink dinamis dalam sel. Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membuat hyperlink dinamis di Excel?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hyperlink dinamis dalam sel. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/","url":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/","name":"\u25b7 Bagaimana cara membuat hyperlink dinamis di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png","datePublished":"2023-11-11T11:35:43+00:00","dateModified":"2023-12-06T06:13:38+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hyperlink dinamis dalam sel. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-pour-creer-hyperlien-dynamiques.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hyperlink-dinamis-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat hyperlink dinamis di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1692"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1692\/revisions"}],"predecessor-version":[{"id":2302,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1692\/revisions\/2302"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}