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.
How to Filter Multiple Columns Independently in Excel: 5 Ideal Examples
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Â
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: How to Hide Filter Buttons in Excel
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 be delivered in July will be filtered.
Therefore, we can say that our method works precisely, and we are able to filter our data in Excel.
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. 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.
Read More: How to Filter Data in Excel Using Formula
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.
Read More: How to Remove Filter in Excel
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
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.
Keep learning new methods and keep growing!
<< Go Back to Data | Filter in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!