{"id":2166,"date":"2023-09-27T13:31:42","date_gmt":"2023-09-27T13:31:42","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/"},"modified":"2023-12-06T06:13:13","modified_gmt":"2023-12-06T06:13:13","slug":"membekukan-rana","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/","title":{"rendered":"Bagaimana cara membekukan panel menggunakan pintasan keyboard excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1102896889\"><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>Di Excel, Freeze Pane adalah fitur yang digunakan untuk membekukan atau mengunci panel saat menggulir ke mana saja di lembar agar data yang dibekukan terlihat.<\/p><p> Saat pengguna bekerja dengan kumpulan data yang sangat besar, mereka lebih memilih untuk membekukan header atau beberapa baris dan kolom tertentu agar terlihat setiap saat saat mereka menggulir ke bagian mana pun pada lembar.<\/p><p> Dengan panel Freeze, pengguna dapat membekukan header saja atau kolom pertama saja, atau kombinasi baris dan kolom tertentu berdasarkan kebutuhannya.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk membekukan panel di Excel<\/h2><p> <kbd>Lainnya<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>R<\/kbd> (hanya membekukan header) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69452\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan-untuk-membekukan-kolom\" width=\"781\" height=\"306\"><\/figure><\/div><p> <kbd>Alt<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>C<\/kbd> (Untuk membekukan kolom pertama saja) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69453\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-pour-geler-len-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan ke header yang dibekukan\" width=\"781\" height=\"306\"><\/figure><\/div><p> <kbd>Alt<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>F<\/kbd> (Untuk membekukan kombinasi baris dan kolom, atau mencairkan panel yang sudah dibekukan) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69454\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-raccourci-pour-figer-les-lignes-et-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan-untuk-membekukan-baris-dan-kolom\" width=\"793\" height=\"311\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah Membekukan Panel Menggunakan Pintasan Keyboard<\/h2><ol><li> Untuk membekukan hanya baris header (baris pertama), cukup klik di mana saja pada lembar dan tekan &#8220;Alt \u2192 W \u2192 F \u2192 R&#8221; secara berurutan, dan baris header Anda akan dibekukan dan akan terlihat sepanjang waktu bahkan saat Anda menggulir ke mana pun di dalam lembaran.<\/li><li> Jika Anda ingin menggulir ke kanan dan membekukan kolom pertama, bukan baris, cukup klik di mana saja pada lembar dan tekan &#8220;Alt \u2192 W \u2192 F \u2192 C&#8221; secara berurutan, dan kolom pertama Anda akan dibekukan.<\/li><li> Untuk membekukan kombinasi baris dan kolom tertentu, navigasikan ke sel di sebelah kiri dan di atas kolom dan baris yang ingin Anda bekukan, lalu tekan &#8220;Alt \u2192 W \u2192 F \u2192 F&#8221; dan kombinasi baris dan kolom Anda akan dibekukan bersama.<\/li><li> Untuk mencairkan panel, cukup tekan \u201cAlt \u2192 W \u2192 F \u2192 F\u201d. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69455\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-colonnes-pour-figer-les-lignes-et-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom-untuk-membekukan-baris-dan-kolom\" width=\"565\" height=\"195\"><\/figure><\/div><p> Pada gambar di atas, pertama-tama kita pergi ke sel C3 lalu menekan Alt \u2192 W \u2192 F \u2192 F yang menyebabkan baris di atas sel ini dan kolom di sebelah kiri sel ini dibekukan sekarang jika kita gulir ke bawah dua baris pertama akan menjadi terlihat sepanjang waktu dan jika kita gulir ke kanan, dua kolom pertama akan terlihat sepanjang waktu. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-55\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-lembar-baru\/\">Tambahkan lembar baru<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-satu-lembar\/\">Hapus lembar<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/temukan-pengganti-1\/\">Temukan dan ganti<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/hyperlink-2\/\">hyperlink<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/memperbesar-memperkecil\/\">Perbesar Perkecil<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">pintasan Excel (lembar contekan PDF)<\/a><\/p><\/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-2166","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>Bagaimana cara membekukan panel menggunakan pintasan keyboard Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan panel beku di Excel. Sekarang jalan pintas ini\" \/>\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-rana\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membekukan panel menggunakan pintasan keyboard Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan panel beku di Excel. Sekarang jalan pintas ini\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.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-rana\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/\",\"name\":\"Bagaimana cara membekukan panel menggunakan pintasan keyboard Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\",\"datePublished\":\"2023-09-27T13:31:42+00:00\",\"dateModified\":\"2023-12-06T06:13:13+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan panel beku di Excel. Sekarang jalan pintas ini\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membekukan panel menggunakan pintasan keyboard 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":"Bagaimana cara membekukan panel menggunakan pintasan keyboard Excel?","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan panel beku di Excel. Sekarang jalan pintas ini","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-rana\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membekukan panel menggunakan pintasan keyboard Excel?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan panel beku di Excel. Sekarang jalan pintas ini","og_url":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.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-rana\/","url":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/","name":"Bagaimana cara membekukan panel menggunakan pintasan keyboard Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png","datePublished":"2023-09-27T13:31:42+00:00","dateModified":"2023-12-06T06:13:13+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan panel beku di Excel. Sekarang jalan pintas ini","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/membekukan-rana\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/membekukan-rana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membekukan panel menggunakan pintasan keyboard 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\/2166","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=2166"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2166\/revisions"}],"predecessor-version":[{"id":2274,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2166\/revisions\/2274"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}