If your Excel worksheet contains a lot of data then it can be hectic to find information quickly. To facilitate this problem, Filter of Excel can be used to filter multiple columns independently. The Filter option can be used to filter texts, dates, numbers, etc., and narrow down the data of the worksheet so that you can only view the data you need. In this article, we will discuss 5 convenient ways of filtering multiple columns independently in Excel. If you are also curious about it, download our practice workbook and follow us.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
5 Ideal Examples of Filter Multiple Columns Independently in Excel
To demonstrate the examples, we consider a dataset of 10 delivery products of a company. The product ID, product name, quantity, delivery location, order date, and shipping date is mentioned in our dataset. So, our dataset is in the range of cells B5:G14. Now, we will filter multiple columns independently.
📚 Note:
All the operations of this article are accomplished by using Microsoft Office 365 application.
1. Filter Data from Columns
In the first example, we are going to apply the Filter command from the Home tab. The steps to complete this example are given below:
📌 Steps:
- First of all, select the range of cells B4:G14.
- Now, in the Home tab, click on the drop-down arrow of the Sort & Filter option and choose the Filter command from the Editing tab.
- You will notice that a drop-down arrow will appear at the right-bottom corner of each column heading.
- Then, click on any drop-down arrow to apply the filter according to your desire. Here, we click on the drop-down arrow of the Delivery Location column and apply the filter only for New York.
- After that, click OK.
- You will see that it will show you the result.
Thus, we can say that our procedure works perfectly, and we are able to filter multiple columns independently in Excel from the Sort & Filter option located in the Home tab.
Read More: How to Filter Multiple Columns Simultaneously in Excel (4 Ways)
2. Using Multiple Filters in Multiple Columns
In the second example, we will apply the multiple filter option on multiple columns. The steps to finish this filtering process are given as follows:
📌 Steps:
- First, select the range of cells B4:G14.
- After that, in the Data tab, click on the Filter option from the Sort & Filter group.
- You will figure out that a drop-down arrow will appear at the right-bottom corner of each column heading.
- Now, click on the drop-down arrow of the Delivery Product name and apply the filter for the Book product.
- Click OK.
- You will see that all the book entities are filtered.
- For another filter, click on any drop-down arrow of another column according to your desire. Here, we click on the drop-down arrow of the Delivery Location column and apply the filter only for New York.
- Again, click OK.
- You will notice that it will show you the result.
Hence, we can say that our method works effectively, and we are able to apply multiple filter to multiple columns independently in Excel.
Read More:Â Filter Different Column by Multiple Criteria in Excel VBA
Similar Readings
- How to Apply Multiple Filters in Excel (6 Suitable Methods)
- Filter Multiple Rows in Excel (11 Suitable Approaches)
- How to Filter with Multiple Criteria in Excel (4 Easy Ways)
- Filter Email Addresses in Excel (5 Easy Ways)
- How to Filter Multiple Columns by Color in Excel (2 Methods)
3. Using Advanced Date Filters
In the following example, we are going to use the advanced data filter option to apply the filter independently. The steps to accomplish this filtering process are described below:
📌 Steps:
- At first, select cell G4.
- Now, in the Data tab, click on the Filter option from the Sort & Filter group.
- A drop-down arrow will appear at the right-bottom corner of each column heading.
- Then, click on the drop-down arrow of the Shipment column and check on the July option.
- Finally, click OK.
- You will see that those products which will deliver in July will be filtered.
Therefore, we can say that our method works precisely, and we are able to filter our data in Excel.
Read More:Â Excel VBA to Filter in Same Column by Multiple Criteria (6 Examples)
4. Use Advanced Number Filters
In this example, we will use advanced number filters to sort the numerical data from smallest to largest. The procedure is explained below step-by-step:
📌 Steps:
- At first, select cell B4:G4.
- Afterward, in the Data tab, click on the Filter option from the Sort & Filter group.
- You will notice a drop-down arrow will appear at the right-bottom corner of each column heading.
- Now, click on the drop-down arrow of the Product ID column and click on the Sort Smallest to Largest option.
- You will figure out that the whole dataset will sort from the filter feature.
So, we can claim that our approach works fruitfully, and we are able to filter our numeric values using the Excel advanced filter option.
Read More:Â How to Filter Column Based on Another Column in Excel (5 Methods)
5. Defining Filter Criteria in Excel Sheet
In the last example, we have to define our filtering criteria which are in the range of cells I4:J5. We are going to use our previous dataset. The steps to complete this example are given as follows:
📌 Steps:
- At the beginning of this approach, go to the Data tab.
- Now, click on the Advanced option from the Sort & Filter group.
- As a result, a small dialog box called Advanced Filter will appear.
- After that, click on the List range field and select the range of cells B4:G14.
- Next, click on the Criteria range field and choose the range of cells I4:J5.
- At last, click OK.
- You will get the data that belong to our criteria.
Finally, we can say that our process works successfully, and we are able to filter according to criteria on multiple columns independently in Excel.
How to Clear an Existing Filter
Now, we will demonstrate to you how to clear an existing filter from an Excel sheet. The filter-clearing procedure is explained below:
📌 Steps:
- First of all, go to the sheet from where you want to remove the filter.
- Now, in the Data tab, click on the Filter option from the Sort & Filter tab.
- You will notice that the filter drop-down will disappear, and the filter will be cleared.
In the end, we can say that our working process works perfectly, and we are able to clear an existing filter from an Excel sheet.
Conclusion
That’s the end of this article. I hope that this article will be helpful for you and you will be able to filter multiple columns independently in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.
Don’t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!
Further Readings
- How to Use Filter in Protected Excel Sheet (With Easy Steps)
- VBA Code to Filter Data by Date in Excel (4 Examples)
- How to Filter Based on Cell Value Using Excel VBA (4 Methods)
- Excel VBA: How to Filter with Multiple Criteria in Array (7 Ways)
- How To Search Multiple Items in Excel Filter (2 Ways)
- Filter Cells with Formulas in Excel (2 Ways)
- How to Filter Data Based on Cell Value in Excel (6 Easy Methods)