{"id":285667,"date":"2021-06-28T17:24:09","date_gmt":"2021-06-28T14:24:09","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-filter-in-google-sheets\/"},"modified":"2021-06-28T17:24:09","modified_gmt":"2021-06-28T14:24:09","slug":"how-to-filter-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-filter-in-google-sheets\/","title":{"rendered":"#How to Filter in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3df9513f18b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3df9513f18b\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-filter-in-google-sheets\/#Enable_the_Filter_in_Google_Sheets\" >Enable the Filter in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-filter-in-google-sheets\/#Filter_by_Color\" >Filter by Color<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-filter-in-google-sheets\/#Filter_by_Condition\" >Filter by Condition<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-filter-in-google-sheets\/#Filter_by_Values\" >Filter by Values<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-filter-in-google-sheets\/#Disable_the_Filter_in_Google_Sheets\" >Disable the Filter in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Filter in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-726282\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/google-sheets-logo.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you have a spreadsheet full of data and need to find something specific, filters in Google Sheets can help. Just enter some criteria for the data you need and see your results in a few clicks.<\/p>\n<p>While filters are robust, they don\u2019t have to be intimidating, so we\u2019re going to go through the basics of <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lying a few simple filters in Google Sheets.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Enable_the_Filter_in_Google_Sheets\"><\/span>Enable the Filter in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you enable the filter feature in Google Sheets, it\u2019s on and ready to use. This applies a filter icon to the top of columns with data. You can then filter whichever column you need.<\/p>\n<p>You might need to select a cell in the data area of your sheet depending on how you set it up. For instance, if you have blocks of data separated by blank columns, choose a cell in the block where you want the filter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729352\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/SelectACellFilter-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a cell for the filter area\" width=\"650\" height=\"209\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Or, if you want to be able to filter any column in the sheet, select the entire sheet by clicking the rectangle on the top left where the A and 1 meet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729351\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/SelectASheetFilter-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the entire sheet\" width=\"650\" height=\"302\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Go to the right side of the toolbar and click \u201cCreate a Filter.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729353\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/CreateAFilter-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Create a Filter\" width=\"469\" height=\"136\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now, you\u2019re ready to apply a filter. You can filter by color, condition, or values.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Filter_by_Color\"><\/span>Filter by Color<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you use color in your spreadsheet to highlight text or cells, you can filter by the colors that you use.<\/p>\n<p>Click the filter icon in the header for the column that you want to filter. Move your cursor to \u201cFilter by Color,\u201d pick \u201cFill Color\u201d or \u201cText Color,\u201d and then choose the color in the pop-out list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729355\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilterByColor-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose Filter by Color and pick a color\" width=\"650\" height=\"341\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your sheet will update with the filtered data, hiding the remaining data in the column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729354\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilteredByColor-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Filtered by Color in Google Sheets\" width=\"650\" height=\"121\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Filter_by_Condition\"><\/span>Filter by Condition<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you want to filter out blank cells or those with certain text, dates, numbers, or formulas. Filtering by condition gives you all of these options with specifics in each one.<\/p>\n<p>For example, you can filter text that starts or ends with something in particular, dates that are before or after another date, or numbers that are greater than or less than a certain value.<\/p>\n<p>Click the filter icon in the column header and expand \u201cFilter by Condition.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729358\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilterByCondition-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Expand Filter by Condition\" width=\"400\" height=\"212\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the drop-down box, choose the condition.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729359\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/Conditions-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Conditions for the filter\" width=\"500\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For our example, we\u2019ll filter numbers that are \u201cGreater Than\u201d or \u201cEqual To\u201d 250.<\/p>\n<p>So, after you pick the condition, enter the value (or formula) in the box directly below it. Click \u201cOK\u201d to apply the filter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729357\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilterByConditionOK-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick a condition, enter a value, and click OK\" width=\"400\" height=\"245\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And there we have it. Only values in our column that are greater than or equal to 250 will display.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729356\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilteredByCondition-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Filtered By Condition in Google Sheets\" width=\"650\" height=\"121\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Filter_by_Values\"><\/span>Filter by Values<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One final way to filter data in Google Sheets is by specific value. When you use this filter, Sheets will display only the values in that column for you, so you can choose those in the list that you want to see or use the Search box to find one quickly.<\/p>\n<p>Click the filter icon in the column header and expand \u201cFilter by Values.\u201d Depending on how much data you have in the column, you might want to use the \u201cSelect All\u201d or \u201cClear\u201d options. Then select or deselect only those that you want.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729361\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilterByValuesSelectClear-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Optionally click Select All or Clear\" width=\"400\" height=\"372\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Alternatively, you can go down to the data list and check or uncheck the values there or find one with the search box. Click \u201cOK\u201d to apply the filter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729362\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilterByValuesSearch-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Search for a filter value and click OK\" width=\"400\" height=\"367\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And like the other filter types, your sheet will update to display only the data in your filter while hiding the rest.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729360\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FilteredByValues-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Filtered By Values in Google Sheets\" width=\"650\" height=\"76\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Disable_the_Filter_in_Google_Sheets\"><\/span>Disable the Filter in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Unlike the filters in Microsoft Excel, Google Sheets doesn\u2019t currently provide a way to clear a filter with a click. So, when you finish using a filter, you can simply turn it off the same way you turned it on.<\/p>\n<p>Go to the right side of the toolbar and click \u201cTurn Off Filter.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-729363\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/TurnOffFilter-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Turn Off Filter\" width=\"468\" height=\"136\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If using the filters in Google Sheets works well for you, you can also save filter views. Check out our tutorial for how to filter when collaborating in Google Sheets, which walks you through it.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/729347\/how-to-filter-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Filter in Google Sheets&#8221; When you have a spreadsheet full of data and need to find something specific, filters in Google Sheets can help. Just enter some criteria for the data you need and see your results in a few clicks. While filters are robust, they don\u2019t have to be intimidating, so we\u2019re&#8230;<\/p>\n","protected":false},"author":1,"featured_media":285668,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/google-sheets-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-285667","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/285667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=285667"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/285667\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/285668"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=285667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=285667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=285667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}