{"id":1829,"date":"2023-10-31T23:56:12","date_gmt":"2023-10-31T23:56:12","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/grup-1\/"},"modified":"2023-12-06T06:16:04","modified_gmt":"2023-12-06T06:16:04","slug":"grup-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/grup-1\/","title":{"rendered":"Bagaimana cara mengelompokkan\/memisahkan spreadsheet?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-655050255\"><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>Pengelompokan lembar kerja di Excel sering digunakan ketika Anda memiliki sekumpulan lembar dengan struktur yang identik dan Anda ingin mengedit lembar tersebut secara bersamaan. Untuk ini, pilihan terbaik untuk mengedit beberapa lembar sekaligus adalah dengan mengelompokkan lembar kerja.<\/p><p> Mengelompokkan lembar kerja saat Anda mengedit, menghapus, menambah, atau melakukan apa pun dalam satu lembar yang terjadi dengan cara yang sama di lembar lain yang dikelompokkan secara bersamaan akan menghemat banyak waktu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63503\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"548\" height=\"570\"><\/figure><\/div><p class=\"has-small-font-size\"> <em>Misalnya, Anda memiliki perusahaan yang memproduksi aksesoris interior mobil dan biaya variabelnya sedikit berbeda setiap bulannya. Dalam hal ini, jika format kumpulan data Anda konstan untuk setiap bulan dan setelah beberapa bulan Anda ingin melihat keseluruhan biaya untuk setiap bulan, Anda cukup mengelompokkan lembar-lembar ini dan setelah Anda memasukkan rumus di salah satu lembar ke temukan biaya keseluruhan, rumus akan menyalin dirinya sendiri ke semua lembar yang dikelompokkan secara bersamaan sehingga Anda akan menghemat waktu dengan memasukkan atau menyalin rumus ke setiap lembar satu per satu.<\/em><\/p><p> Anda juga dapat menggunakan opsi lembar kerja grup untuk menyembunyikan beberapa lembar sekaligus daripada menyembunyikannya satu per satu.<\/p><h2 id=\"h-steps-to-group-worksheets-in-excel\" class=\"wp-block-heading\"> Langkah-langkah Mengelompokkan Lembar Kerja di Excel<\/h2><ol><li> Pertama, tahan tombol kontrol pada keyboard Anda.<\/li><li> Setelah itu, klik pada tab sheet (satu per satu untuk dipilih) yang ingin Anda kelompokkan. <br><img loading=\"lazy\" decoding=\"async\" title=\"tab\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-onglets-de-feuille-de-calcul-selectionnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-worksheet-tabs\" width=\"382\" height=\"111\"><\/li><li> Sekarang Anda perlu melepaskan tombol kontrol.<\/li><li> Pada titik ini, semua lembar yang dipilih dikelompokkan menjadi satu. <br><img loading=\"lazy\" decoding=\"async\" title=\"png\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-feuilles-groupees-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"416\" height=\"251\"><\/li><\/ol><p class=\"mytip\"> Jika lembar kerja yang ingin Anda kelompokkan berdekatan, klik tab lembar pertama, tahan Shift, dan klik tab lembar terakhir.<\/p><h2 id=\"h-group-all-worksheets\" class=\"wp-block-heading\"> Kelompokkan semua spreadsheet<\/h2><ol><li> Pertama, klik kanan pada tab lembar mana pun di buku kerja. <br><img decoding=\"async\" title=\"G\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-onglets-de-feuille-de-calcul.png\" sizes=\"\" srcset=\"\" alt=\"worksheet-tabs\"><\/li><li> Setelah itu, Anda akan mendapatkan jendela pop-up dengan beberapa pilihan.<\/li><li> Sekarang pilih opsi <strong>&#8220;Pilih semua lembar&#8221;<\/strong> . <br><img loading=\"lazy\" decoding=\"async\" title=\"\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-selectionner-toutes-les-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-all-sheets\" width=\"304\" height=\"321\"><\/li><li> Pada titik ini, semua lembar Anda di buku kerja dikelompokkan bersama. <br><img loading=\"lazy\" decoding=\"async\" title=\"daun-daun\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-toutes-les-feuilles-de-travail-groupees.png\" sizes=\"auto, \" srcset=\"\" alt=\"all-grouped-worksheets\" width=\"447\" height=\"228\"><\/li><\/ol><h2 id=\"h-ungroup-worksheets\" class=\"wp-block-heading\"> Pisahkan spreadsheet<\/h2><ol><li> Pertama, klik kanan pada tab lembar mana pun di grup. <br><img decoding=\"async\" title=\"tab\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-onglets-de-feuille-de-calcul-selectionnes.png\" sizes=\"\" srcset=\"\" alt=\"select-worksheet-tabs\"><\/li><li> Setelah itu, Anda akan mendapatkan jendela pop-up dengan beberapa pilihan.<\/li><li> Sekarang pilih opsi <strong>\u201cPisahkan Lembar\u201d<\/strong> . <br><img loading=\"lazy\" decoding=\"async\" title=\"G\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-feuilles-de-degroupage.png\" sizes=\"auto, \" srcset=\"\" alt=\"ungroup-sheets\" width=\"295\" height=\"329\"><\/li><li> Terakhir, buku kerja Anda tidak dikelompokkan. <br><img loading=\"lazy\" decoding=\"async\" title=\"bit\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-feuilles-de-travail-non-groupees.png\" sizes=\"auto, \" srcset=\"\" alt=\"ungrouped-worksheets\" width=\"457\" height=\"236\"><\/li><\/ol><p class=\"mytip\"> Anda juga dapat mengklik tab lembar mana pun di luar grup dan tab yang dikelompokkan menjadi tidak dikelompokkan.<\/p><h2 id=\"h-how-to-find-if-worksheets-are-grouped-in-excel\" class=\"wp-block-heading\"> Bagaimana mengetahui apakah lembar kerja dikelompokkan di Excel<\/h2><ol type=\"1\"><li> Anda akan selalu menemukan kata &#8220;Grup&#8221; di nama file jika lembar-lembar tersebut dikelompokkan dalam buku kerja ini.<\/li><li> Anda akan menemukan warna latar belakang semua tab dikelompokkan menjadi putih, kecuali tidak ada yang mengubah warna tab pada tab lembar kerja. <\/li><\/ol><div class=\"gb-container gb-container-3044ba66 gb-container-mt\"><p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja\/\" data-wpil=\"url\">Lembar Bentang Excel<\/a><\/strong><\/p><h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> Tutorial lainnya <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-7495e031\"><div class=\"gb-container gb-container-7495e031\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengkonsolidasikan\/\">Konsolidasikan data dari beberapa spreadsheet<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\">Ganti nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/\">Lihat dua lembar berdampingan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan\/\">Tambahkan spreadsheet di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-warna-tab\/\">Ubah Warna Tab di Excel (Tab Lembar Kerja)<\/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-1829","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 mengelompokkan dan memisahkan lembar kerja di Excel?<\/title>\n<meta name=\"description\" content=\"Pengelompokan lembar kerja di Excel sering digunakan ketika Anda memiliki sekumpulan lembar yang terstruktur...\" \/>\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\/grup-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengelompokkan dan memisahkan lembar kerja di Excel?\" \/>\n<meta property=\"og:description\" content=\"Pengelompokan lembar kerja di Excel sering digunakan ketika Anda memiliki sekumpulan lembar yang terstruktur...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/grup-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.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\/grup-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/grup-1\/\",\"name\":\"Bagaimana cara mengelompokkan dan memisahkan lembar kerja di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/grup-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/grup-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.png\",\"datePublished\":\"2023-10-31T23:56:12+00:00\",\"dateModified\":\"2023-12-06T06:16:04+00:00\",\"description\":\"Pengelompokan lembar kerja di Excel sering digunakan ketika Anda memiliki sekumpulan lembar yang terstruktur...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/grup-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/grup-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/grup-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/grup-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengelompokkan\/memisahkan spreadsheet?\"}]},{\"@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 mengelompokkan dan memisahkan lembar kerja di Excel?","description":"Pengelompokan lembar kerja di Excel sering digunakan ketika Anda memiliki sekumpulan lembar yang terstruktur...","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\/grup-1\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengelompokkan dan memisahkan lembar kerja di Excel?","og_description":"Pengelompokan lembar kerja di Excel sering digunakan ketika Anda memiliki sekumpulan lembar yang terstruktur...","og_url":"https:\/\/exceladvisor.org\/id\/grup-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.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\/grup-1\/","url":"https:\/\/exceladvisor.org\/id\/grup-1\/","name":"Bagaimana cara mengelompokkan dan memisahkan lembar kerja di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/grup-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/grup-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.png","datePublished":"2023-10-31T23:56:12+00:00","dateModified":"2023-12-06T06:16:04+00:00","description":"Pengelompokan lembar kerja di Excel sering digunakan ketika Anda memiliki sekumpulan lembar yang terstruktur...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/grup-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/grup-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/grup-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuilles-de-groupe-exemple-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/grup-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengelompokkan\/memisahkan spreadsheet?"}]},{"@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\/1829","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=1829"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1829\/revisions"}],"predecessor-version":[{"id":2487,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1829\/revisions\/2487"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}