{"id":179679,"date":"2024-02-28T09:53:36","date_gmt":"2024-02-28T08:53:36","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=179679"},"modified":"2024-02-25T10:59:25","modified_gmt":"2024-02-25T09:59:25","slug":"streamline-data-analysis-how-to-apply-filters-in-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel","title":{"rendered":"Streamline Data Analysis: How to Apply Filters in Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"179679\" class=\"elementor elementor-179679\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-077c074 e-flex e-con-boxed e-con\" data-id=\"077c074\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-db2102e e-con-full e-flex e-con\" data-id=\"db2102e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7e7ee0e elementor-widget elementor-widget-text-editor\" data-id=\"7e7ee0e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h2>Your Excel spreadsheet is too cluttered. Do you feel like you&#8217;re drowning in an ocean of data? Don&#8217;t panic, this article is here to help you find the relevant data with the Filters in Excel.<\/h2>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-317bdd0 e-flex e-con-boxed e-con\" data-id=\"317bdd0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-720dd8f e-con-full e-flex e-con\" data-id=\"720dd8f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c76066b elementor-widget elementor-widget-heading\" data-id=\"c76066b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">What is the role of a Filter in Excel?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b62d5aa e-flex e-con-boxed e-con\" data-id=\"b62d5aa\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3f892ce e-con-full e-flex e-con\" data-id=\"3f892ce\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-db07886 elementor-widget elementor-widget-text-editor\" data-id=\"db07886\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <b>Filter in Excel, <\/b>also known as an automatic filter, is a practical approach to displaying only the data that&#8217;s important at a given moment and hiding all other data. In Excel worksheets, you can filter rows by value, format and criteria. You can copy, edit, create charts or print only those rows visible after applying a filter without reorganizing the complete list.<\/p><p>In addition to a variety of filtering choices, Excel AutoFilter also includes sorting options for each column:<\/p><ul><li>Sort A to Z, Sort Z to A, and Sort by color for text values.<\/li><li>Sort numbers in the following order: smallest to largest, largest to smallest, and by color.<\/li><li>Sort oldest to newest, newest to oldest, and sort by color for dates.<\/li><\/ul><p>\u00a0<\/p><p>Here&#8217;s the d<strong>istinction between sorting and filtering in Excel:<\/strong><\/p><p>When you sort data in Excel, it rearranges the whole table, for example alphabetically or from smallest to largest value. Sorting does not hide any entries; it simply reorganizes the data.<\/p><p>By contrast, when you<strong> filter data in Excel,<\/strong> only the items you want to see are displayed, and all unnecessary items are temporarily hidden.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup> <col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power Query Date Format: How to change it on Excel and Power BI&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\" target=\"_blank\" rel=\"noopener\">Power Query Date Format: How to change it on Excel and Power BI<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Standard deviations in Excel: What's it for? How do I calculate it?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/standard-deviations-in-excel-whats-it-for-how-do-i-calculate-it\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/standard-deviations-in-excel-whats-it-for-how-do-i-calculate-it\" target=\"_blank\" rel=\"noopener\">Standard deviations in Excel: What&#8217;s it for? How do I calculate it?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel VBA: How to automate tasks with this language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\" target=\"_blank\" rel=\"noopener\">Excel VBA: How to automate tasks with this language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Pie Chart Excel: Mastering Data Visualization &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\" target=\"_blank\" rel=\"noopener\">Pie Chart Excel: Mastering Data Visualization <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Creating Stunning Excel Charts: A Step-by-Step Guide&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\" target=\"_blank\" rel=\"noopener\">Creating Stunning Excel Charts: A Step-by-Step Guide<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-aaee3d8 e-flex e-con-boxed e-con\" data-id=\"aaee3d8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-c98d6ec e-con-full e-flex e-con\" data-id=\"c98d6ec\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ba87bae elementor-widget elementor-widget-heading\" data-id=\"ba87bae\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I add a filter in Excel? <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-26243c0 elementor-widget elementor-widget-text-editor\" data-id=\"26243c0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For <strong>Excel AutoFilter<\/strong> to work properly, your dataset will need to include a header row with column names, as shown in the screenshot below.<\/p><p>The dataset will include a header row where the filter buttons will be placed.<\/p><p>Select any cell in your dataset and use one of the following techniques to insert a filter once the column headers are in place.<\/p><p>In Excel, there are two ways to add <b>Filter in Excel:<\/b><\/p><ul><li>Click on the Filter button in the Sort &amp; Filter group of the Data tab.<\/li><li>Click on Sort &amp; Filter &gt; Filter in the Home tab, in the Edit group.<\/li><\/ul><p>There&#8217;s another way to <strong>filter in Excel:<\/strong><\/p><ul><li>Activate or deactivate filters using the Excel Filter shortcut: Ctrl+Shift+L<\/li><li>The drop-down arrows will appear in each header cell, regardless of the approach used.<\/li><li>The presence of a downward arrow in the column header indicates that filtering has been introduced but not yet applied. An on-screen indication appears when you hover over the arrow (Show All).<\/li><\/ul><p>To filter data in Excel, proceed as follows:<\/p><ul><li>To filter a column, click on the drop-down arrow next to it.<\/li><li>To easily deselect all data, uncheck the (Select All) box.<\/li><li>Click OK after ticking the boxes next to the data you wish to see.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a0b514 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4a0b514\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Training in data analysis<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-47225af elementor-widget elementor-widget-heading\" data-id=\"47225af\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I filter multiple columns with Filter in Excel?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c557705 e-con-full e-flex e-con\" data-id=\"c557705\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3ac42d3 elementor-widget elementor-widget-text-editor\" data-id=\"3ac42d3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Simply repeat the above procedures<\/strong> for the number of columns to which you wish to apply an Excel filter.<\/p><p>To widen or lengthen the Excel filter window, hover over the handle at the bottom and drag it down or to the right as soon as the double arrow appears.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c492d8a e-con-full e-flex e-con\" data-id=\"c492d8a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b2fc02c elementor-widget elementor-widget-heading\" data-id=\"b2fc02c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How to filter cells?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7625d3e e-flex e-con-boxed e-con\" data-id=\"7625d3e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-2001852 e-con-full e-flex e-con\" data-id=\"2001852\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a1b7a15 elementor-widget elementor-widget-text-editor\" data-id=\"a1b7a15\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To filter data in Excel and eliminate blanks or non-blanks, use one of the following methods:<\/p><ul><li>Click on the automatic filter arrow, check the box (Select all), then uncheck (Empty) at the bottom of the list to filter out blanks and display non-blank cells. Only rows with any value in a specific column will be displayed.<\/li><li>To display only blank cells and filter out non-blank cells, deselect &#8220;select all&#8221;, then select &#8220;blank&#8221;. This will display only those rows in a particular column that have an empty cell.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-94901df e-flex e-con-boxed e-con\" data-id=\"94901df\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-fce9387 e-con-full e-flex e-con\" data-id=\"fce9387\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9205f42 elementor-widget elementor-widget-heading\" data-id=\"9205f42\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I filter text data? <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c3570e9 e-flex e-con-boxed e-con\" data-id=\"c3570e9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-37f9e97 e-con-full e-flex e-con\" data-id=\"37f9e97\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b86bfbd elementor-widget elementor-widget-text-editor\" data-id=\"b86bfbd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>When you need to filter a column of text for something specific, Excel provides a number of advanced options, including:<\/p><ul><li>Filter cells that begin or end with a specific character.<\/li><li>Filter text cells that do or don&#8217;t include a specific character or term.<\/li><li>Filter cells that are exactly equivalent or not to a particular character.<\/li><\/ul><p>Text filters appear automatically in the &#8220;<strong>Text Filters<\/strong>&#8221; menu after you have applied a filter to a column containing text values:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ccc043a e-flex e-con-boxed e-con\" data-id=\"ccc043a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-bca4b50 e-con-full e-flex e-con\" data-id=\"bca4b50\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a3ec9e3 elementor-widget elementor-widget-heading\" data-id=\"a3ec9e3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I filter numbers in Excel? <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f1bed9b e-flex e-con-boxed e-con\" data-id=\"f1bed9b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-0fb86c4 e-con-full e-flex e-con\" data-id=\"0fb86c4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2693b93 elementor-widget elementor-widget-text-editor\" data-id=\"2693b93\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The Excel number filter lets you filter numerical data in the following ways:<\/p><ul><li>Filter numbers, greater than, less than, or within the range of specific numbers.<\/li><li>Filter cells with numbers above or below the mean.<\/li><li>Filter numbers equal to or not equal to a certain number.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-408a0a9 e-flex e-con-boxed e-con\" data-id=\"408a0a9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-e3ad174 e-con-full e-flex e-con\" data-id=\"e3ad174\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e91b282 elementor-widget elementor-widget-heading\" data-id=\"e91b282\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I filter dates in Excel?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1e81b80 e-flex e-con-boxed e-con\" data-id=\"1e81b80\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3fe86bf e-con-full e-flex e-con\" data-id=\"3fe86bf\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-24a2275 elementor-widget elementor-widget-text-editor\" data-id=\"24a2275\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The<strong> date filter<\/strong> offers a wide range of choices, allowing you to show or hide data for a particular day, week, month, quarter or year, before or after a given date, or between two dates.<\/p><p>The screenshot below shows all available date filters:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9b1ea74 e-flex e-con-boxed e-con\" data-id=\"9b1ea74\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-11dc975 e-con-full e-flex e-con\" data-id=\"11dc975\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2ac2550 elementor-widget elementor-widget-text-editor\" data-id=\"2ac2550\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Excel offers a wide range of filtering and sorting options. Each one serves a specific purpose. Just scroll through the various filter menus to see the power of the tool. And now it&#8217;s your turn to usea <b>Filter in Excel!<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-30b9b45 e-flex e-con-boxed e-con\" data-id=\"30b9b45\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-a403344 e-con-full e-flex e-con\" data-id=\"a403344\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bd5ed4e elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"bd5ed4e\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Data training courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bff79ab e-flex e-con-boxed e-con\" data-id=\"bff79ab\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-4aa2ea0 e-con-full e-flex e-con\" data-id=\"4aa2ea0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ad958a1 elementor-widget elementor-widget-html\" data-id=\"ad958a1\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is the role of an Excel filter?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The Excel filter, also known as an automatic filter, is a practical approach to displaying only the data that is important at a given moment and hiding all other data. In Excel worksheets, you can filter rows by value, format and criteria. You can copy, edit, create charts or print only those rows visible after applying a filter without rearranging the complete list.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I add a filter to Excel?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"For Excel AutoFilter to work properly, your dataset will need a header row with column names, as shown in the screenshot below.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I filter multiple columns? \",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Simply repeat the above procedures for the number of columns to which you wish to apply an Excel filter. To widen or lengthen the Excel filter window, hover over the handle at the bottom and drag it down or to the right as soon as the double arrow appears.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I filter cells?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"To filter data in Excel and eliminate blanks or non-blanks, use one of the following methods: Click on the automatic filter arrow, check the box (Select all), then uncheck (Empty) at the bottom of the list to filter out blanks and display non-blank cells. Only rows with any value in a specific column will be displayed.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I filter text data?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"When you need to filter a column of text for something specific, Excel provides a number of advanced options, including: Filter cells that begin or end with a specific character. Filter text cells that do or don't include a specific character or term. Filter cells that are exactly equivalent or not to a particular character.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Your Excel spreadsheet is too cluttered. Do you feel like you&#8217;re drowning in an ocean of data? Don&#8217;t panic, this article is here to help you find the relevant data with the Filters in Excel. What is the role of a Filter in Excel? The Filter in Excel, also known as an automatic filter, is [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":179676,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Streamline Data Analysis: How to Apply Filters in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to efficiently filter data in Excel to focus on specific information and streamline your data analysis process. Follow these simple steps to apply filters and uncover valuable insights with ease.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Streamline Data Analysis: How to Apply Filters in Excel\" \/>\n<meta property=\"og:description\" content=\"Your Excel spreadsheet is too cluttered. Do you feel like you&#039;re drowning in an ocean of data? Don&#039;t panic, this article is here to help you find the\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-28T08:53:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-25T09:59:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/02\/excel-makro.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Streamline Data Analysis: How to Apply Filters in Excel\",\"datePublished\":\"2024-02-28T08:53:36+00:00\",\"dateModified\":\"2024-02-25T09:59:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\"},\"wordCount\":893,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\",\"url\":\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\",\"name\":\"Streamline Data Analysis: How to Apply Filters in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-02-28T08:53:36+00:00\",\"dateModified\":\"2024-02-25T09:59:25+00:00\",\"description\":\"Learn how to efficiently filter data in Excel to focus on specific information and streamline your data analysis process. Follow these simple steps to apply filters and uncover valuable insights with ease.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Streamline Data Analysis: How to Apply Filters in Excel","description":"Learn how to efficiently filter data in Excel to focus on specific information and streamline your data analysis process. Follow these simple steps to apply filters and uncover valuable insights with ease.","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:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel","og_locale":"en_GB","og_type":"article","og_title":"Streamline Data Analysis: How to Apply Filters in Excel","og_description":"Your Excel spreadsheet is too cluttered. Do you feel like you're drowning in an ocean of data? Don't panic, this article is here to help you find the","og_url":"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-02-28T08:53:36+00:00","article_modified_time":"2024-02-25T09:59:25+00:00","og_image":[{"width":900,"height":450,"url":"https:\/\/datascientest.com\/en\/files\/2024\/02\/excel-makro.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Streamline Data Analysis: How to Apply Filters in Excel","datePublished":"2024-02-28T08:53:36+00:00","dateModified":"2024-02-25T09:59:25+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel"},"wordCount":893,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel","url":"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel","name":"Streamline Data Analysis: How to Apply Filters in Excel","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-02-28T08:53:36+00:00","dateModified":"2024-02-25T09:59:25+00:00","description":"Learn how to efficiently filter data in Excel to focus on specific information and streamline your data analysis process. Follow these simple steps to apply filters and uncover valuable insights with ease.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/179679"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=179679"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/179679\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/179676"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=179679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=179679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=179679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}