{"id":4090,"date":"2023-07-13T16:14:39","date_gmt":"2023-07-13T16:14:39","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/"},"modified":"2023-07-13T16:14:39","modified_gmt":"2023-07-13T16:14:39","slug":"filter-google-sheet-berdasarkan-warna","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/","title":{"rendered":"Cara memfilter sel berdasarkan warna di google spreadsheet (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fitur <strong>Filter menurut Warna<\/strong> di Google Spreadsheet untuk memfilter sel dalam rentang di Google Spreadsheet berdasarkan warna isiannya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan dataset berikut ke Google Sheets yang berisi informasi berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32526 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fc1-1.png\" alt=\"\" width=\"625\" height=\"536\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap sel di kolom <strong>Tim<\/strong> diisi dengan warna biru, hijau, atau kuning.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat filter<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin memfilter kumpulan data untuk memperlihatkan hanya baris yang selnya di kolom <strong>Tim<\/strong> memiliki warna isian hijau.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Caranya, tambahkan filter terlebih dahulu dengan memilih cell range <strong>A1:B11<\/strong> , lalu klik tab <strong>Data<\/strong> , lalu klik <strong>Create Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32527 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fc2-1.png\" alt=\"\" width=\"622\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ikon filter kecil akan ditambahkan ke setiap sel di baris pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32528 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fc3-1.png\" alt=\"\" width=\"525\" height=\"499\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Filter berdasarkan warna<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk memfilter baris agar hanya menampilkan tim yang isiannya berwarna hijau, kita bisa klik ikon filter kecil di samping <strong>Team<\/strong> , lalu klik <strong>Filter by color<\/strong> , lalu klik <strong>Fill color<\/strong> , lalu klik <strong>hijau muda 2<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32529\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fc4-1.png\" alt=\"Filter Google Spreadsheet berdasarkan warna\" width=\"673\" height=\"518\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Setelah kita mengklik <strong>hijau muda 2<\/strong> , kumpulan data akan secara otomatis difilter untuk hanya menampilkan tim dengan isian hijau:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32530 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fc5-1.png\" alt=\"\" width=\"493\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengeklik warna berbeda di menu tarik-turun untuk memfilter sel menurut warna isian berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda juga dapat menggunakan opsi <strong>Urutkan berdasarkan Warna<\/strong> yang terletak tepat di atas opsi <strong>Filter menurut Warna<\/strong> jika Anda ingin mengurutkan sel berdasarkan warna sel alih-alih memfilter sel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memfilter-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter beberapa kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-daftar-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter berdasarkan daftar nilai di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter dari sheet lain di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fitur Filter menurut Warna di Google Spreadsheet untuk memfilter sel dalam rentang di Google Spreadsheet berdasarkan warna isiannya. Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan dataset berikut ke Google Sheets yang berisi informasi berbagai pemain bola basket: Perhatikan [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Memfilter Sel berdasarkan Warna di Google Spreadsheet (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter sel berdasarkan warna di Google Sheets, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memfilter Sel berdasarkan Warna di Google Spreadsheet (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter sel berdasarkan warna di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T16:14:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fc1-1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/\",\"name\":\"Cara Memfilter Sel berdasarkan Warna di Google Spreadsheet (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T16:14:39+00:00\",\"dateModified\":\"2023-07-13T16:14:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter sel berdasarkan warna di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memfilter sel berdasarkan warna di google spreadsheet (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Memfilter Sel berdasarkan Warna di Google Spreadsheet (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara memfilter sel berdasarkan warna di Google Sheets, dengan sebuah contoh.","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:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memfilter Sel berdasarkan Warna di Google Spreadsheet (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter sel berdasarkan warna di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/","og_site_name":"Statorials","article_published_time":"2023-07-13T16:14:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fc1-1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/","url":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/","name":"Cara Memfilter Sel berdasarkan Warna di Google Spreadsheet (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T16:14:39+00:00","dateModified":"2023-07-13T16:14:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter sel berdasarkan warna di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-google-sheet-berdasarkan-warna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memfilter sel berdasarkan warna di google spreadsheet (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4090"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4090"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4090\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}