{"id":8970,"date":"2019-08-29T06:50:21","date_gmt":"2019-08-29T04:50:21","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=8970"},"modified":"2019-08-29T06:50:23","modified_gmt":"2019-08-29T04:50:23","slug":"how-to-filter-a-list-of-data-for-multiple-items-excel-2007","status":"publish","type":"post","link":"https:\/\/www.officetodo.com\/public\/how-to-filter-a-list-of-data-for-multiple-items-excel-2007\/","title":{"rendered":"How to filter a list of data for multiple items? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\n\nFirst off you need to apply filter to your column. To do that select the row, cell or cells you wish for the filter to appear and go to Home tab under Editing section. Click on &#8220;Sort &amp; Filter&#8221; and choose &#8220;Filter&#8221; from the menu. Now click on the appearing small arrow inside the cell and uncheck &#8220;(Select All)&#8221; from the selection menu and check the boxes representing the items you wish to appear on your selection.\n\n<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to filter a list of data for multiple items? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/6fu9KSZftbU?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>First off you need to apply filter to your column. To do that select the row, cell or cells you wish for the filter to appear and go to Home tab under Editing section. Click on &#8220;Sort &amp; Filter&#8221; and choose &#8220;Filter&#8221; from the menu. Now click on the appearing small arrow inside the cell [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3501],"tags":[3572,3509,3577,3576],"class_list":["post-8970","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-data","tag-excel-2007","tag-items","tag-multiple"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=8970"}],"version-history":[{"count":1,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8970\/revisions"}],"predecessor-version":[{"id":8971,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/8970\/revisions\/8971"}],"wp:attachment":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=8970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=8970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=8970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}