{"id":9316,"date":"2019-10-30T07:54:11","date_gmt":"2019-10-30T05:54:11","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9316"},"modified":"2019-10-30T07:54:12","modified_gmt":"2019-10-30T05:54:12","slug":"how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/","title":{"rendered":"How to easily select items from the filter ignoring just a few? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The easiest\nsolution would be to first select all by checking the box next to &#8220;(Select\nAll)&#8221; and then removing checks from boxes representing the items you wish\nto ignore in your selection.<\/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 easily select items from the filter ignoring just a few? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/98f_oSnLX-M?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>The easiest solution would be to first select all by checking the box next to &#8220;(Select All)&#8221; and then removing checks from boxes representing the items you wish to ignore in your selection.<\/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":[3509,3588,3577],"class_list":["post-9316","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-excel-2007","tag-filter","tag-items"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"The easiest solution would be to first select all by checking the box next to &quot;(Select All)&quot; and then removing checks from boxes representing the items you wish to ignore in your selection.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Karl\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#article\",\"name\":\"How to easily select items from the filter ignoring just a few? | Excel 2007 | Office ToDo\",\"headline\":\"How to easily select items from the filter ignoring just a few? | Excel 2007\",\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"},\"datePublished\":\"2019-10-30T07:54:11+02:00\",\"dateModified\":\"2019-10-30T07:54:12+02:00\",\"inLanguage\":\"en\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#webpage\"},\"articleSection\":\"Excel 2007, excel 2007, filter, items\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"position\":2,\"name\":\"MS Office\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"name\":\"Excel 2007\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"position\":3,\"name\":\"Excel 2007\",\"item\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#listItem\",\"name\":\"How to easily select items from the filter ignoring just a few? | Excel 2007\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/#listItem\",\"name\":\"MS Office\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#listItem\",\"position\":4,\"name\":\"How to easily select items from the filter ignoring just a few? | Excel 2007\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/lessons\\\/ms-office\\\/excel-2007\\\/#listItem\",\"name\":\"Excel 2007\"}}]},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\",\"name\":\"Office ToDo\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/\",\"name\":\"Karl\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#webpage\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/\",\"name\":\"How to easily select items from the filter ignoring just a few? | Excel 2007 | Office ToDo\",\"description\":\"The easiest solution would be to first select all by checking the box next to \\\"(Select All)\\\" and then removing checks from boxes representing the items you wish to ignore in your selection.\",\"inLanguage\":\"en\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\\\/#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2019-10-30T07:54:11+02:00\",\"dateModified\":\"2019-10-30T07:54:12+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#website\",\"url\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/\",\"name\":\"Office ToDo\",\"inLanguage\":\"en\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.officetodo.com\\\/public\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to easily select items from the filter ignoring just a few? | Excel 2007 | Office ToDo","description":"The easiest solution would be to first select all by checking the box next to \"(Select All)\" and then removing checks from boxes representing the items you wish to ignore in your selection.","canonical_url":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#article","name":"How to easily select items from the filter ignoring just a few? | Excel 2007 | Office ToDo","headline":"How to easily select items from the filter ignoring just a few? | Excel 2007","author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"},"datePublished":"2019-10-30T07:54:11+02:00","dateModified":"2019-10-30T07:54:12+02:00","inLanguage":"en","mainEntityOfPage":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#webpage"},"isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#webpage"},"articleSection":"Excel 2007, excel 2007, filter, items"},{"@type":"BreadcrumbList","@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","position":1,"name":"Home","item":"http:\/\/www.officetodo.com\/public","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","position":2,"name":"MS Office","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","name":"Excel 2007"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","position":3,"name":"Excel 2007","item":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#listItem","name":"How to easily select items from the filter ignoring just a few? | Excel 2007"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/#listItem","name":"MS Office"}},{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#listItem","position":4,"name":"How to easily select items from the filter ignoring just a few? | Excel 2007","previousItem":{"@type":"ListItem","@id":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/#listItem","name":"Excel 2007"}}]},{"@type":"Organization","@id":"http:\/\/www.officetodo.com\/public\/#organization","name":"Office ToDo","url":"http:\/\/www.officetodo.com\/public\/"},{"@type":"Person","@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author","url":"http:\/\/www.officetodo.com\/public\/author\/admin\/","name":"Karl"},{"@type":"WebPage","@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#webpage","url":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/","name":"How to easily select items from the filter ignoring just a few? | Excel 2007 | Office ToDo","description":"The easiest solution would be to first select all by checking the box next to \"(Select All)\" and then removing checks from boxes representing the items you wish to ignore in your selection.","inLanguage":"en","isPartOf":{"@id":"http:\/\/www.officetodo.com\/public\/#website"},"breadcrumb":{"@id":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/#breadcrumblist"},"author":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"creator":{"@id":"http:\/\/www.officetodo.com\/public\/author\/admin\/#author"},"datePublished":"2019-10-30T07:54:11+02:00","dateModified":"2019-10-30T07:54:12+02:00"},{"@type":"WebSite","@id":"http:\/\/www.officetodo.com\/public\/#website","url":"http:\/\/www.officetodo.com\/public\/","name":"Office ToDo","inLanguage":"en","publisher":{"@id":"http:\/\/www.officetodo.com\/public\/#organization"}}]}},"aioseo_meta_data":{"post_id":"9316","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-08-05 05:06:52","updated":"2026-05-27 00:07:04","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/\" title=\"MS Office\">MS Office<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/\" title=\"Excel 2007\">Excel 2007<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to easily select items from the filter ignoring just a few? | Excel 2007\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.officetodo.com\/public"},{"label":"MS Office","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/"},{"label":"Excel 2007","link":"http:\/\/www.officetodo.com\/public\/lessons\/ms-office\/excel-2007\/"},{"label":"How to easily select items from the filter ignoring just a few? | Excel 2007","link":"http:\/\/www.officetodo.com\/public\/how-to-easily-select-items-from-the-filter-ignoring-just-a-few-excel-2007\/"}],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=9316"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9316\/revisions"}],"predecessor-version":[{"id":9317,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9316\/revisions\/9317"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9316"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}