{"id":2081,"date":"2023-10-20T02:28:14","date_gmt":"2023-10-20T02:28:14","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/"},"modified":"2023-12-06T06:20:41","modified_gmt":"2023-12-06T06:20:41","slug":"referensi-mutlak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/","title":{"rendered":"Pintasan keyboard excel untuk referensi absolut"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-702396927\"><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>Referensi absolut mengacu pada referensi sel yang tidak berpindah saat menyalin dan memindahkan rumus.<\/p><p> Di Excel, setiap kali Anda menggunakan referensi sel dalam rumus, Excel memindahkan referensi sel dengan menyalin atau memindahkan rumus ke sel lain dan referensi ini disebut referensi relatif.<\/p><p> Namun terkadang pengguna ingin memperbaiki atau mengunci referensi sel yang digunakan pada rumus genap jika rumus tersebut disalin atau dipindahkan ke sel lain dan untuk itu pengguna dapat mengubah referensi relatif menjadi referensi absolut.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk referensi mutlak<\/h2><p> Pintasan keyboard untuk membuat referensi sel relatif menjadi referensi sel absolut adalah di bawah ini:<\/p><p> <kbd>Fn<\/kbd> <strong>+<\/strong> <kbd>F4<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67487\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.png\" sizes=\"auto, \" srcset=\"\" alt=\"jalan pintas ke referensi absolut\" width=\"870\" height=\"341\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah untuk mengubah referensi menjadi referensi absolut menggunakan pintasan keyboard<\/h2><p> Sebagai referensi mutlak, pengguna dapat mengunci referensi sel tertentu atau referensi kolom atau baris saja.<\/p><ul><li> Pertama masukkan rumusnya, lalu pilih referensi sel yang ingin Anda tetapkan absolut, lalu tekan tombol pintas \u201c <kbd>Fn<\/kbd> + <kbd>F4<\/kbd> \u201d.<\/li><li> Setelah Anda menekan &#8220;Fn+F4&#8221;, Excel akan menambahkan tanda dolar ($) di awal kolom dan baris untuk membuat referensi sel yang dipilih (kombinasi baris dan kolom) menjadi absolut.<\/li><li> Sekarang, meskipun Anda memindahkan atau menyalin rumus ke mana pun dalam sheet, referensi sel Anda &#8220;E3&#8221; seperti pada contoh di bawah ini tidak akan berubah atau berpindah sama sekali. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67488\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-reference-absolue-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"referensi mutlak\" width=\"481\" height=\"193\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Kesimpulan<\/h2><ul><li> Jika ingin mengunci referensi sel (kombinasi baris dan kolom), dimana sel yang direferensikan tidak akan berpindah, tekan <kbd>Fn<\/kbd> + <kbd>F4<\/kbd> sekali saja.<\/li><li> Mengunci referensi baris saja berarti kolom akan berpindah tetapi baris yang direferensikan dalam rumus tetap terkunci, tekan &#8220;Fn + F4&#8221; dua kali.<\/li><li> Referensi kolom kunci saja artinya baris akan berpindah dengan memindahkan rumus ke baris lain tetapi kolom tidak akan berpindah, tekan \u201cFn+F4\u201d tiga kali.<\/li><li> Untuk merujuk ke referensi relatif lagi, tekan \u201cFn + F4\u201d empat kali. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Lebih banyak jalan pintas <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-35\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\">Salin dan tempel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/\">Potong dan tempel<\/a><\/li><li> Kunci sel<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pergi-ke\/\">Buka opsi Buka<\/a><\/li><\/ul><\/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-2081","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 Apa yang dimaksud dengan pintasan keyboard referensi absolut?<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan pintasan keyboard untuk menerapkan referensi absolut di Excel. Sekarang pintasan keyboard ini mencakup...\" \/>\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\/referensi-mutlak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Apa yang dimaksud dengan pintasan keyboard referensi absolut?\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan pintasan keyboard untuk menerapkan referensi absolut di Excel. Sekarang pintasan keyboard ini mencakup...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.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\/referensi-mutlak\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/\",\"name\":\"\u25b7 Apa yang dimaksud dengan pintasan keyboard referensi absolut?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.png\",\"datePublished\":\"2023-10-20T02:28:14+00:00\",\"dateModified\":\"2023-12-06T06:20:41+00:00\",\"description\":\"Pelajari cara menggunakan pintasan keyboard untuk menerapkan referensi absolut di Excel. Sekarang pintasan keyboard ini mencakup...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pintasan keyboard excel untuk referensi absolut\"}]},{\"@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 Apa yang dimaksud dengan pintasan keyboard referensi absolut?","description":"Pelajari cara menggunakan pintasan keyboard untuk menerapkan referensi absolut di Excel. Sekarang pintasan keyboard ini mencakup...","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\/referensi-mutlak\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Apa yang dimaksud dengan pintasan keyboard referensi absolut?","og_description":"Pelajari cara menggunakan pintasan keyboard untuk menerapkan referensi absolut di Excel. Sekarang pintasan keyboard ini mencakup...","og_url":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.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\/referensi-mutlak\/","url":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/","name":"\u25b7 Apa yang dimaksud dengan pintasan keyboard referensi absolut?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.png","datePublished":"2023-10-20T02:28:14+00:00","dateModified":"2023-12-06T06:20:41+00:00","description":"Pelajari cara menggunakan pintasan keyboard untuk menerapkan referensi absolut di Excel. Sekarang pintasan keyboard ini mencakup...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/referensi-mutlak\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-vers-la-reference-absolue.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pintasan keyboard excel untuk referensi absolut"}]},{"@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\/2081","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=2081"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2081\/revisions"}],"predecessor-version":[{"id":2934,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2081\/revisions\/2934"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}