How to Filter Multiple Columns Independently in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

Use the Filter command from the Home tab to filter on multiple columns independently in Excel

  • 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.

Apply filter on multiple columns for New York city

  • You will see that it will show you the result.

Filter Data from Multiple Columns Independently

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.

Using Filter command from the Data tab

  • 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.

Applying the first filter on a column in Excel

  • You will see that all the book entities are filtered.

Filtered result after first filter

  • 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.Applying Multiple Filters in Multiple Columns Independently in Excel

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


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.

Use the Filter option from the Data tab

  • 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.

Using Advanced Date Filters to Filter Multiple Columns Independently

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.

Using Sort Smallest to Largest Option

  • You will figure out that the whole dataset will sort from the filter feature.

Use Advanced Number Filters Option to Filter Multiple Columns Independently

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.

Defining suitable criteria to filter dataset

  • You will get the data that belong to our criteria.

Defining Filter Criteria in Excel Sheet to Filter Multiple Columns Independently

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.

Click on Filter command to clear from dataset

  • 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

 

Ratul Khan

Ratul Khan

Hello! Here is my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and I am very interested in research.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo