{"id":85,"date":"2018-12-27T04:14:49","date_gmt":"2018-12-27T04:14:49","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=85"},"modified":"2021-09-29T06:05:07","modified_gmt":"2021-09-29T06:05:07","slug":"filter-blanks","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/filter-blanks\/","title":{"rendered":"How to solve when filter function does not work properly in MS Excel?"},"content":{"rendered":"\r\n<p><span style=\"color: #000000;\">One of the most common problem with filter function is that it stops working beyond a blank row. Filter will not include cells beyond the first blank.\u00a0<\/span><\/p>\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<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.howtoexcel.info\/Images\/Filter_Blanks\/excel_to_filter_blanks1.JPG\" width=\"606\" height=\"510\" border=\"0\" \/><\/p>\r\n\r\n\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;\">External links for other issues that might prevent filter function to work properly.<\/span><\/p>\r\n<p><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/excelatwork.co.nz\/2018\/06\/03\/5-reasons-why-your-excel-filter-may-not-be-working\/\"><strong>Reasons why your Excel filter may not be working<\/strong><\/a><\/span><\/p>\r\n<p><span style=\"color: #0000ff;\"><strong> <a style=\"color: #0000ff;\" href=\"http:\/\/www.excelforum.com\/excel-general\/765847-excel-wont-filter-whole-column.html\">Excel how to filter properly<\/a><\/strong><\/span><\/p>\r\n<p><span style=\"color: #0000ff;\"><strong><a style=\"color: #0000ff;\" href=\"https:\/\/www.pcreview.co.uk\/forums\/filters-not-include-cells-beyond-first-blank-t3812841.html\">Filters do not include cells beyond first blank<\/a><\/strong><\/span><\/p>\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 function not working properly in Excel 2007, 2010<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Excel not filtering the entire column<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Excel not filtering all entries<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Filter not showing all data in a column<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Unable to filter properly in MS Excel<\/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\/85"}],"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=85"}],"version-history":[{"count":17,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/85\/revisions"}],"predecessor-version":[{"id":272,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/85\/revisions\/272"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}