{"id":94,"date":"2018-12-27T16:25:49","date_gmt":"2018-12-27T16:25:49","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=94"},"modified":"2021-09-29T06:04:46","modified_gmt":"2021-09-29T06:04:46","slug":"filter-checkbox-to-show-blanks","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/filter-checkbox-to-show-blanks\/","title":{"rendered":"How to solve if excel do not filter blank cells? (Filter checklist do not show blanks)"},"content":{"rendered":"\r\n<p><span style=\"color: #000000;\">To avoid this issue, select the range before applying the filter function. Please refer to the following excel spreadsheet for example.<\/span><\/p>\r\n<p><span style=\"color: #000000;\">1. Before applying filter on column C, either select the entire column C or the data that needs to be filtered.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Filter_Blanks\/excel_to_filter_blanks1.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> 2. Select Filter option under Data tab. Now all items appear in the filtered list as well as filter checkbox list.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Filter_Blanks\/excel_to_filter_blanks2.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> Similarly you may select multiple columns or a range of cells before applying the filter.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Filter_Blanks\/excel_to_filter_blanks3.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000; font-size: 12px;\"><strong>Search engine keywords for this question:<\/strong><\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Filter blank cells in Excel 2007, 2010<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">How to include blanks in filter<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Show blank rows in filter<\/span><\/p>\r\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/94"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":6,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":271,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/94\/revisions\/271"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}