{"id":344,"date":"2013-06-27T08:49:11","date_gmt":"2013-06-27T08:49:11","guid":{"rendered":"http:\/\/www.siriinnovations.com\/blog\/?p=344"},"modified":"2014-07-11T06:22:55","modified_gmt":"2014-07-11T06:22:55","slug":"use-autofilter-ms-excel","status":"publish","type":"post","link":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/","title":{"rendered":"How to Use AutoFilter in MS Excel"},"content":{"rendered":"<p>For medium-to-large quantities of data, using Microsoft Excel\u2019s AutoFilter is a quick and simple way to filter through that information and find what you need.<\/p>\n<p>Input all of your data, or open the spreadsheet that contains all of your data. It is best that your data have column heading such as categories to specify the data below it. If you don&#8217;t already have these, input them before the filter.<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-345\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/1-300x188.png\" alt=\"1\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<p>Select<b> all the data you wish to filter<\/b>.<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-346\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/2-300x188.png\" alt=\"2\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<ul>\n<li>Because the AutoFilter option is an automatic process that does not receive any specific inputs on how to filter, it is recommended that you choose \u2018\u2019all\u2019\u2019 of the data you have. This will avoid the possibility to loose\u00a0data associations across rows and\/or columns.<\/li>\n<\/ul>\n<p class=\"none\">\n<p><b>Click \u201cData\u201d, then select \u201cF<\/b><\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-347\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/3-300x188.png\" alt=\"3\" width=\"300\" height=\"188\" \/><\/a><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/3.png\"><br \/>\n<\/a><\/p>\n<p><b>You will immediately notice that the categories have drop-down buttons<\/b>. Using these buttons, you can set your filter options.<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/4.png\"><br \/>\n<\/a><\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-348\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/4-300x188.png\" alt=\"4\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Sort Ascending<\/strong>: Sorts data in ascending order based on the data in that column; numbers are sorted 1, 2, 3, 4, 5, etc. and words are sorted alphabetically starting with a, b, c, d, e, etc.<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-349\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/5-300x188.png\" alt=\"5\" width=\"300\" height=\"188\" \/><\/a><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/4.png\"><br \/>\n<\/a><\/p>\n<p><strong>Sort Descending<\/strong>: Sorts data in descending order based on the data in that column; numbers are sorted in reverse order 5, 4, 3, 2, 1, etc. and words are sorted in reverse alphabetical order, e, d, c, b, a, etc.<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-354\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/6-300x188.png\" alt=\"6\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<p><strong>Top 10<\/strong>: The first 10 rows of data in your spreadsheet (when initial setting is \u201cAll\u201d) or the first 10 rows of data from the filtered selection<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-353\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/7-300x188.png\" alt=\"7\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<p><strong>Custom<\/strong>: You may customize how Excel sorts the data based on data ranges and information.<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-352\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/8-300x188.png\" alt=\"8\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<p><strong>Various data points<\/strong>: You may sort the data based on all other data points in that column. Excel combines data points that are the same. For example, employees that live in the same city can be sorted using only one data point<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-351\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/9-300x188.png\" alt=\"9\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<p><b>To turn off AutoFilter, repeat step 3 to uncheck the AutoFilter option<\/b>.<\/p>\n<p><a href=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-350\" src=\"http:\/\/www.siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/10-300x188.png\" alt=\"10\" width=\"300\" height=\"188\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For medium-to-large quantities of data, using Microsoft Excel\u2019s AutoFilter is a quick and simple way to filter through that information and find what you need. Input all of your data, or open the spreadsheet that contains all of your data. It is best that your data have column heading such as categories to specify the [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":1049,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-344","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Use AutoFilter in MS Excel - Siri Innovations<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use AutoFilter in MS Excel - Siri Innovations\" \/>\n<meta property=\"og:description\" content=\"For medium-to-large quantities of data, using Microsoft Excel\u2019s AutoFilter is a quick and simple way to filter through that information and find what you need. Input all of your data, or open the spreadsheet that contains all of your data. It is best that your data have column heading such as categories to specify the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Siri Innovations\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-27T08:49:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-07-11T06:22:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"540\" \/>\n\t<meta property=\"og:image:height\" content=\"241\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Parvateesh G\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Parvateesh G\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/\"},\"author\":{\"name\":\"Parvateesh G\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/da9fb2303e2e90f4884afadd100d12e7\"},\"headline\":\"How to Use AutoFilter in MS Excel\",\"datePublished\":\"2013-06-27T08:49:11+00:00\",\"dateModified\":\"2014-07-11T06:22:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/\"},\"wordCount\":314,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg\",\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/\",\"url\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/\",\"name\":\"How to Use AutoFilter in MS Excel - Siri Innovations\",\"isPartOf\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg\",\"datePublished\":\"2013-06-27T08:49:11+00:00\",\"dateModified\":\"2014-07-11T06:22:55+00:00\",\"author\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/da9fb2303e2e90f4884afadd100d12e7\"},\"breadcrumb\":{\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage\",\"url\":\"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg\",\"contentUrl\":\"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg\",\"width\":540,\"height\":241},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/siriinnovations.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Use AutoFilter in MS Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/#website\",\"url\":\"https:\/\/siriinnovations.com\/blog\/\",\"name\":\"Technical blog from Siri Innovations\",\"description\":\"Innovative like no other\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/siriinnovations.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/da9fb2303e2e90f4884afadd100d12e7\",\"name\":\"Parvateesh G\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a7a7edc78566ac57d3375b70f7c5b501d8836d615da049e51ab3da205102423e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a7a7edc78566ac57d3375b70f7c5b501d8836d615da049e51ab3da205102423e?s=96&d=mm&r=g\",\"caption\":\"Parvateesh G\"},\"url\":\"https:\/\/siriinnovations.com\/blog\/author\/parvateesh\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Use AutoFilter in MS Excel - Siri Innovations","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Use AutoFilter in MS Excel - Siri Innovations","og_description":"For medium-to-large quantities of data, using Microsoft Excel\u2019s AutoFilter is a quick and simple way to filter through that information and find what you need. Input all of your data, or open the spreadsheet that contains all of your data. It is best that your data have column heading such as categories to specify the [&hellip;]","og_url":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/","og_site_name":"Siri Innovations","article_published_time":"2013-06-27T08:49:11+00:00","article_modified_time":"2014-07-11T06:22:55+00:00","og_image":[{"width":540,"height":241,"url":"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg","type":"image\/jpeg"}],"author":"Parvateesh G","twitter_misc":{"Written by":"Parvateesh G","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#article","isPartOf":{"@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/"},"author":{"name":"Parvateesh G","@id":"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/da9fb2303e2e90f4884afadd100d12e7"},"headline":"How to Use AutoFilter in MS Excel","datePublished":"2013-06-27T08:49:11+00:00","dateModified":"2014-07-11T06:22:55+00:00","mainEntityOfPage":{"@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/"},"wordCount":314,"commentCount":0,"image":{"@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg","articleSection":["General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/","url":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/","name":"How to Use AutoFilter in MS Excel - Siri Innovations","isPartOf":{"@id":"https:\/\/siriinnovations.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage"},"image":{"@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg","datePublished":"2013-06-27T08:49:11+00:00","dateModified":"2014-07-11T06:22:55+00:00","author":{"@id":"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/da9fb2303e2e90f4884afadd100d12e7"},"breadcrumb":{"@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#primaryimage","url":"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg","contentUrl":"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg","width":540,"height":241},{"@type":"BreadcrumbList","@id":"https:\/\/siriinnovations.com\/blog\/use-autofilter-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/siriinnovations.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Use AutoFilter in MS Excel"}]},{"@type":"WebSite","@id":"https:\/\/siriinnovations.com\/blog\/#website","url":"https:\/\/siriinnovations.com\/blog\/","name":"Technical blog from Siri Innovations","description":"Innovative like no other","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/siriinnovations.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/da9fb2303e2e90f4884afadd100d12e7","name":"Parvateesh G","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/siriinnovations.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a7a7edc78566ac57d3375b70f7c5b501d8836d615da049e51ab3da205102423e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7a7edc78566ac57d3375b70f7c5b501d8836d615da049e51ab3da205102423e?s=96&d=mm&r=g","caption":"Parvateesh G"},"url":"https:\/\/siriinnovations.com\/blog\/author\/parvateesh\/"}]}},"jetpack_featured_media_url":"https:\/\/siriinnovations.com\/blog\/wp-content\/uploads\/2013\/06\/27..jpg","_links":{"self":[{"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/posts\/344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/comments?post=344"}],"version-history":[{"count":7,"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/posts\/344\/revisions"}],"predecessor-version":[{"id":1052,"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/posts\/344\/revisions\/1052"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/media\/1049"}],"wp:attachment":[{"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/media?parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/categories?post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/siriinnovations.com\/blog\/wp-json\/wp\/v2\/tags?post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}