{"id":1898,"date":"2023-10-29T08:03:11","date_gmt":"2023-10-29T08:03:11","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/"},"modified":"2023-12-06T06:15:34","modified_gmt":"2023-12-06T06:15:34","slug":"menerapkan-beberapa-filter","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/","title":{"rendered":"Bagaimana cara menerapkan banyak filter ke kolom di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3515985919\"><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, jika Anda memiliki beberapa kolom dalam data dan ingin memfilter beberapa kolom, Anda bisa melakukannya dengan mudah. Saat Anda menerapkan filter ke rentang data berkelanjutan, Excel memungkinkan Anda memfilter beberapa kolom.<\/p><p> Dalam tutorial ini, kita akan melihat langkah mudah untuk menerapkan filter multi-kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72663\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"menerapkan beberapa filter\" width=\"685\" height=\"296\"><\/figure><\/div><p> Pada data di atas, kita perlu menerapkan filter pada dua kolom \u201ctype\u201d dan \u201ccontributed_by\u201d.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Menerapkan Beberapa Filter di Excel<\/h2><ol><li> Pertama, gunakan <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">pintasan keyboard<\/a> (Alt \u21e2 D \u21e2 F \u21e2 F) untuk <a href=\"https:\/\/exceladvisor.org\/id\/menyaring-1\/\">menerapkan filter<\/a> , atau Anda juga dapat membuka Beranda \u21e2 Sortir &amp; Filter \u21e2 Filter. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-terapkan-filter\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-appliquer-le-filtre.png\" sizes=\"auto, \" srcset=\"\" alt=\"apply-filter\" width=\"717\" height=\"184\"><\/li><li> Selanjutnya, Anda perlu mengklik menu drop-down filter untuk kolom \u201ctype\u201d dan dari sana Anda perlu menghapus centang semua nilai selain \u201cCity\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"Filter tarik-turun dalam 3 klik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cliquez-sur-la-liste-deroulante-des-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-on-filter-dropdown\" width=\"507\" height=\"390\"><\/li><li> Setelah itu, klik OK untuk menerapkan filter. Dan ketika Anda melakukannya, itu akan memfilter semua data berdasarkan kolom \u201cKota\u201d dari kolom \u201ctipe\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-ok-untuk-menerapkan-filter\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ok-pour-appliquer-le-filtre.png\" sizes=\"auto, \" srcset=\"\" alt=\"ok-to-apply-filter\" width=\"576\" height=\"199\"><\/li><li> Selanjutnya, masuk ke kolom \u201ccontributed_by\u201d dan buka menu drop-down filter dan hapus centang semua nilai selain \u201cKenny Cunanan\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-buka-filter-dropdown\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ouvrir-la-liste-deroulante-des-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-the-filter-dropdown\" width=\"520\" height=\"398\"><\/li><li> Pada akhirnya, klik OK untuk menerapkan filter.<\/li><\/ol><p> Setelah ini selesai, beberapa filter akan diterapkan ke data Anda. Satu di kolom \u201ctype\u201d dan satu lagi di kolom \u201ccontributed_by\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72669\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-filtres-multiples-appliques.png\" sizes=\"auto, \" srcset=\"\" alt=\"beberapa filter diterapkan\" width=\"643\" height=\"345\"><\/figure><\/div><p> Tidak hanya dua, Anda bisa menerapkan beberapa filter ke kolom sebanyak yang Anda inginkan. Anda dapat melangkah lebih jauh dan menerapkan filter tambahan ke kolom \u201cnegara bagian\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72670\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-appliquer-plusieurs-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"menerapkan beberapa filter\" width=\"778\" height=\"163\"><\/figure><\/div><p> Pada contoh di atas, kita memiliki filter ketiga pada kolom &#8220;state&#8221; di mana kita telah memfilter semua nilai dengan CA.<\/p><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\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/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\/alat-analisis-cepat\/\">Alat Analisis Cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\">Sorot nilai N atas dan bawah di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kotak-centang\/\">Sisipkan kotak centang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-tanpa-kehilangan-data\/\">Gabungkan sel tanpa kehilangan data di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tempel-perkalian-khusus\/\">Kalikan di Excel menggunakan Paste Special<\/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-1898","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 menerapkan banyak filter ke kolom di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menerapkan beberapa filter ke kolom di Excel dengan langkah-langkah yang mudah diikuti.\" \/>\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-beberapa-filter\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menerapkan banyak filter ke kolom di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menerapkan beberapa filter ke kolom di Excel dengan langkah-langkah yang mudah diikuti.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.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-beberapa-filter\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\",\"name\":\"Bagaimana cara menerapkan banyak filter ke kolom di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\",\"datePublished\":\"2023-10-29T08:03:11+00:00\",\"dateModified\":\"2023-12-06T06:15:34+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menerapkan beberapa filter ke kolom di Excel dengan langkah-langkah yang mudah diikuti.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menerapkan banyak filter ke kolom 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":"Bagaimana cara menerapkan banyak filter ke kolom di Excel?","description":"Dalam tutorial ini, kita akan mempelajari cara menerapkan beberapa filter ke kolom di Excel dengan langkah-langkah yang mudah diikuti.","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-beberapa-filter\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menerapkan banyak filter ke kolom di Excel?","og_description":"Dalam tutorial ini, kita akan mempelajari cara menerapkan beberapa filter ke kolom di Excel dengan langkah-langkah yang mudah diikuti.","og_url":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.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-beberapa-filter\/","url":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/","name":"Bagaimana cara menerapkan banyak filter ke kolom di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png","datePublished":"2023-10-29T08:03:11+00:00","dateModified":"2023-12-06T06:15:34+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menerapkan beberapa filter ke kolom di Excel dengan langkah-langkah yang mudah diikuti.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menerapkan banyak filter ke kolom 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\/1898","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=1898"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1898\/revisions"}],"predecessor-version":[{"id":2427,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1898\/revisions\/2427"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}