{"id":2207,"date":"2023-09-25T00:44:32","date_gmt":"2023-09-25T00:44:32","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/"},"modified":"2023-12-06T06:15:35","modified_gmt":"2023-12-06T06:15:35","slug":"menerapkan-batas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/","title":{"rendered":"Bagaimana cara menerapkan batas melalui pintasan excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-602941557\"><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>Excel tidak menerapkan batas apa pun ke sel, namun ada beberapa tipe opsi batas yang tersedia untuk diterapkan ke sel, rentang, atau lembar kerja secara manual oleh pengguna atau menggunakan pintasan keyboard.<\/p><p> Dalam tutorial ini, kami telah menjelaskan beberapa pintasan keyboard untuk menerapkan batas di Excel.<\/p><h2 class=\"wp-block-heading\"> Tombol pintas untuk menerapkan batas di Excel<\/h2><p> Opsi batas yang paling umum digunakan adalah &#8220;Semua Batas&#8221; yang menerapkan batas pada semua sisi sel.<\/p><p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>A<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan-untuk-menerapkan-perbatasan\" width=\"774\" height=\"303\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah Menerapkan Perbatasan Menggunakan Pintasan Keyboard<\/h2><ul><li> Pertama, pilih sel, rentang sel, atau seluruh data di lembar kerja menggunakan \u201cCtrl + A\u201d untuk memilih sel yang ingin Anda beri batas. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-pilih-rentang\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionner-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-range\" width=\"437\" height=\"206\"><\/li><li> Setelah itu, tekan Alt \u2192 H \u2192 B \u2192 A secara berurutan dan Anda akan mendapatkan batas yang diterapkan ke semua sisi setiap sel yang dipilih. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 batas diterapkan ke sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-bordure-appliquee-aux-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"border-applied-to-the-cells\" width=\"438\" height=\"207\"><\/li><\/ul><h2 class=\"wp-block-heading\"> Tombol pintas untuk menerapkan berbagai jenis batas<\/h2><p> Kombinasi tombol pintas untuk menerapkan semua jenis batas adalah sama kecuali tombol terakhir dalam kombinasi tersebut berubah tergantung pada jenis batas yang ingin Anda terapkan.<\/p><ol><li> Terapkan batas ke bagian bawah sel: <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>O<\/kbd><\/li><li> Terapkan batas ke bagian atas sel: Alt \u2192 H \u2192 B \u2192 P<\/li><li> Terapkan batas di sebelah kiri sel: Alt \u2192 H \u2192 B \u2192 L<\/li><li> Terapkan batas di sebelah kanan sel: Alt \u2192 H \u2192 B \u2192 R<\/li><li> Terapkan batas hanya di luar rentang yang dipilih: Alt \u2192 H \u2192 B \u2192 S<\/li><li> Terapkan batas tebal hanya di luar rentang yang dipilih: Alt \u2192 H \u2192 B \u2192 T<\/li><li> Terapkan batas ganda ke bagian bawah sel: Alt \u2192 H \u2192 B \u2192 B<\/li><li> Terapkan batas ganda tebal ke bagian bawah sel: Alt \u2192 H \u2192 B \u2192 H <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70421\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-types-de-bordures-multiples.png\" sizes=\"auto, \" srcset=\"\" alt=\"beberapa jenis perbatasan\" width=\"225\" height=\"512\"><\/figure><\/div><p> Untuk menemukan dan menerapkan lebih banyak opsi batas Tekan \u201cAlt \u2192 H \u2192 B \u2192 M\u201d dan Anda akan membuka kotak dialog \u201cFormat Sel\u201d dengan lebih banyak opsi batas untuk dipilih. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70422\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-autres-options-de-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"lebih banyak opsi perbatasan\" width=\"549\" height=\"441\"><\/figure><\/div><div class=\"gb-container gb-container-2116538e gb-container-mt\"> <a class=\"gb-button gb-button-f7d2c131 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">Pintasan keyboard Excel<\/a><h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> Lebih banyak jalan pintas <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-edeef538 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6ab6fbc6\"><div class=\"gb-container gb-container-6ab6fbc6\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/buka-opsi-format-sel\/\">Pilihan untuk membuka sel format<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/penyesuaian-otomatis\/\">Penyesuaian otomatis<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/format-pelukis-1\/\">Format pelukis<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bungkus-teks\/\">Bungkus teks<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-komentar\/\">Tambahkan komentar<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-766d598b\"><div class=\"gb-container gb-container-766d598b\"><\/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-2207","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 menerapkan batas melalui pintasan Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan batas di Excel dan semua informasi terkait.\" \/>\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\/menerapkan-batas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menerapkan batas melalui pintasan Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan batas di Excel dan semua informasi terkait.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.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\/menerapkan-batas\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/\",\"name\":\"\u25b7 Bagaimana cara menerapkan batas melalui pintasan Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\",\"datePublished\":\"2023-09-25T00:44:32+00:00\",\"dateModified\":\"2023-12-06T06:15:35+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan batas di Excel dan semua informasi terkait.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menerapkan batas melalui pintasan 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 menerapkan batas melalui pintasan Excel?","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan batas di Excel dan semua informasi terkait.","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\/menerapkan-batas\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menerapkan batas melalui pintasan Excel?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan batas di Excel dan semua informasi terkait.","og_url":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:35+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.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\/menerapkan-batas\/","url":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/","name":"\u25b7 Bagaimana cara menerapkan batas melalui pintasan Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png","datePublished":"2023-09-25T00:44:32+00:00","dateModified":"2023-12-06T06:15:35+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan batas di Excel dan semua informasi terkait.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menerapkan-batas\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menerapkan-batas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menerapkan batas melalui pintasan 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\/2207","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=2207"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2207\/revisions"}],"predecessor-version":[{"id":2428,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2207\/revisions\/2428"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}