{"id":1857,"date":"2023-10-31T03:53:22","date_gmt":"2023-10-31T03:53:22","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/"},"modified":"2023-12-06T06:13:12","modified_gmt":"2023-12-06T06:13:12","slug":"membekukan-daun-jendela","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/","title":{"rendered":"Bagaimana cara membekukan panel di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1938382608\"><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>Opsi Freeze Panes memungkinkan Anda mengunci baris dan kolom saat menggulir lembar kerja ke mana saja. Saat bekerja dengan data besar, sulit untuk membandingkannya satu sama lain.<\/p><p> Namun, Anda dapat membekukan header atau beberapa baris dan kolom tertentu agar selalu terlihat di atas.<\/p><p> Pada tutorial kali ini saya ingin membagikan langkah-langkah untuk membekukan baris atas atau kolom pertama, serta kombinasi baris dan kolom yang sesuai.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Membekukan Baris Teratas di Excel<\/h2><ol><li> Pertama, pilih \u201cbaris header\u201d yang ingin Anda bekukan.<\/li><li> Selanjutnya, buka tab \u201cLihat\u201d pada pita dan, di grup \u201cJendela\u201d, klik perintah \u201cBekukan Panel\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-header untuk dibekukan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png\" sizes=\"auto, \" srcset=\"\" alt=\"header-to-freeze\" width=\"979\" height=\"261\"><\/li><li> Sekarang, dari daftar drop-down panel bekukan, pilih opsi \u201cBekukan Baris Atas\u201d untuk mengunci baris. <br><img loading=\"lazy\" decoding=\"async\" title=\"2 baris atas bebas pilih\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-choisissez-la-rangee-superieure-libre.png\" sizes=\"auto, \" srcset=\"\" alt=\"choose-freeze-top-row\" width=\"393\" height=\"259\"><\/li><li> Di sini Anda akan melihat garis horizontal tipis di bawah baris header yang menunjukkan bahwa area lembar di atas terkunci. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 baris atas dibekukan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-rangees-du-haut-gelees.png\" sizes=\"auto, \" srcset=\"\" alt=\"top-row-freezed\" width=\"405\" height=\"194\"><\/li><\/ol><p> Pintasan keyboardnya adalah Alt \u21e2 W \u21e2 F \u21e2 R untuk membekukan baris atas.<\/p><h2 class=\"wp-block-heading\"> Bekukan beberapa baris di bagian atas di Excel<\/h2><p> Dalam hal ini Anda juga dapat membekukan beberapa baris di spreadsheet sesuai kebutuhan Anda. Berikut adalah langkah-langkah yang harus diikuti:<\/p><ol><li> Pertama, arahkan kursor ke nomor header baris dari baris yang ditargetkan untuk membekukan area di atasnya. (Misalnya, jika Anda ingin membekukan tiga baris pertama, Anda harus memilih baris <sup>ke-4<\/sup> untuk itu).<\/li><li> Setelah itu, di tab \u201cView\u201d, klik pada daftar drop-down freeze panes dan pilih opsi pertama yaitu \u201cLock Panes\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"4 es krim\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-volets-de-gel.png\" sizes=\"auto, \" srcset=\"\" alt=\"freeze-panes\" width=\"670\" height=\"250\"><\/li><li> Sekarang gulir ke bawah lembar dan Anda akan melihat bahwa semua baris di atas baris <sup>ke-4<\/sup> akan terlihat di atas sebagaimana adanya. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-di atas-garis-yang dipilih-terlihat1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-selectionnees-au-dessus-visibles1.png\" sizes=\"auto, \" srcset=\"\" alt=\"above-selected-rows-visible\" width=\"408\" height=\"171\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Bekukan kolom pertama di Excel<\/h2><p> Untuk mengetahui cara membekukan kolom pertama lembar kerja, Anda perlu mengikuti langkah-langkah di bawah ini:<\/p><ol><li> Pilih kolom alfabet atas \u201cA\u201d yang menunjukkan kolom A pada lembar.<\/li><li> Sekali lagi, di grup Window, klik menu drop-down Freeze Panes.<\/li><li> Pada langkah selanjutnya, Anda perlu mengklik opsi \u201cBekukan Kolom Pertama\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-gel-kolom pertama1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-geler-la-premiere-colonne1.png\" sizes=\"auto, \" srcset=\"\" alt=\"freeze-first-column\" width=\"626\" height=\"275\"><\/li><li> Pada akhirnya, kolom pertama membeku, memperlihatkan garis vertikal gelap. <br><img loading=\"lazy\" decoding=\"async\" title=\"7 garis vertikal gelap\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-ligne-verticale-sombre.png\" sizes=\"auto, \" srcset=\"\" alt=\"dark-vertical-line\" width=\"341\" height=\"237\"><\/li><\/ol><p> Pintasan keyboard untuk membekukan kolom pertama adalah Alt \u21e2 W \u21e2 F \u21e2 C.<\/p><h2 class=\"wp-block-heading\"> Bekukan beberapa kolom<\/h2><ol><li> Pertama, Anda perlu memilih kolom pertama berdasarkan headernya, lalu tekan dan tahan tombol Ctrl untuk memilih beberapa kolom yang akan dikunci. Misalnya, jika Anda ingin membekukan dua kolom pertama (A, B) pada lembar Anda, maka untuk ini, Anda juga harus memilih kolom C.<\/li><li> Setelah itu, buka tab \u201cView\u201d &gt; Freeze Panes &gt; dan klik lagi Freeze Panes dari daftar drop-down. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-bekukan-beberapa kolom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-geler-plusieurs-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"freeze-multiple-columns\" width=\"645\" height=\"264\"><\/li><li> Setelah Anda mengklik panci beku, dua kolom pertama (A dan B) akan dikunci dan kolom ini akan dipisahkan satu sama lain dengan garis vertikal lurus. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-kolom-dua-beku-pertama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-deux-premieres-colonnes-figees.png\" sizes=\"auto, \" srcset=\"\" alt=\"first-two-columns-freezed\" width=\"327\" height=\"266\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Cairkan panel di Excel<\/h2><ol><li> Buka saja tab &#8220;Tampilan&#8221; di pita.<\/li><li> Selanjutnya, klik tombol \u201cUnfreeze Panes\u201d di panci beku. <br><img loading=\"lazy\" decoding=\"async\" title=\"10 jendela yang dicairkan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-vitres-degelees.png\" sizes=\"auto, \" srcset=\"\" alt=\"unfreeze-panes\" width=\"625\" height=\"257\"><\/li><li> Dalam sedetik, Anda akan melihat semua baris dan kolom yang terkunci kembali normal. <br><img loading=\"lazy\" decoding=\"async\" title=\"11-baris-dan-kolom-tidak tetap\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-lignes-et-colonnes-non-figees.png\" sizes=\"auto, \" srcset=\"\" alt=\"rows-and-columns-unfreezed\" width=\"314\" height=\"217\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Membawa pergi<\/h2><ul><li> Kolom atau baris yang terkunci akan selalu dimulai dari baris paling atas dan kolom pertama. Karena tidak mungkin mengunci baris atau kolom tengah di lembar.<\/li><li> Pastikan semua baris dan kolom yang ingin Anda kunci terlihat di lembar kerja.<\/li><\/ul><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Microsoft Excel (Komponen, Bagian dan Catatan Pengetahuan)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/pembenaran-lengkap\/\">Isi Justify di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bilah-rumus-excel\/\">Bilah rumus di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-header-footer\/\">Tambahkan header dan footer di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/penggaris\/\">Tampilkan penggaris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pegangan-pengisian\/\">Isi pegangan di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1857","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 membekukan panel di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menggunakan opsi freeze pane di Excel. Opsi ini memungkinkan Anda untuk membekukan baris pertama atau\" \/>\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\/membekukan-daun-jendela\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membekukan panel di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menggunakan opsi freeze pane di Excel. Opsi ini memungkinkan Anda untuk membekukan baris pertama atau\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/\",\"name\":\"\u25b7 Bagaimana cara membekukan panel di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png\",\"datePublished\":\"2023-10-31T03:53:22+00:00\",\"dateModified\":\"2023-12-06T06:13:12+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menggunakan opsi freeze pane di Excel. Opsi ini memungkinkan Anda untuk membekukan baris pertama atau\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membekukan panel 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 membekukan panel di Excel? (Tutorial 2023)","description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan opsi freeze pane di Excel. Opsi ini memungkinkan Anda untuk membekukan baris pertama atau","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\/membekukan-daun-jendela\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membekukan panel di Excel? (Tutorial 2023)","og_description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan opsi freeze pane di Excel. Opsi ini memungkinkan Anda untuk membekukan baris pertama atau","og_url":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/","url":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/","name":"\u25b7 Bagaimana cara membekukan panel di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png","datePublished":"2023-10-31T03:53:22+00:00","dateModified":"2023-12-06T06:13:12+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan opsi freeze pane di Excel. Opsi ini memungkinkan Anda untuk membekukan baris pertama atau","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-tete-a-figer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/membekukan-daun-jendela\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membekukan panel 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\/1857","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=1857"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1857\/revisions"}],"predecessor-version":[{"id":2273,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1857\/revisions\/2273"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}