0610 Filter - Applying 2 or More Filters Simultaneously on the Same Sheet

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.22
You save:  A$55.78
List Price:  ৳11,874.82
You save:  ৳3,393.05
List Price:  CA$185.28
You save:  CA$52.94
CHF 91.10
List Price:  CHF 127.54
You save:  CHF 36.44
List Price:  kr884.03
You save:  kr252.59
List Price:  €118.72
You save:  €33.92
List Price:  £107.32
You save:  £30.66
List Price:  HK$1,085.03
You save:  HK$310.03
List Price:  ₹10,472.62
You save:  ₹2,992.39
List Price:  RM587.04
You save:  RM167.74
List Price:  ₦53,336.19
You save:  ₦15,240
List Price:  kr1,250.97
You save:  kr357.44
List Price:  NZ$212.50
You save:  NZ$60.71
List Price:  ₱6,854.21
You save:  ₱1,958.48
List Price:  ₨23,539.31
You save:  ₨6,726
List Price:  S$192
You save:  S$54.86
List Price:  ฿4,349.48
You save:  ฿1,242.80
List Price:  ₺1,020.31
You save:  ₺291.53
List Price:  R2,440.10
You save:  R697.22
Already have an account? Log In


Hi, today I discuss a special trick with you with respect to filter question straightforward to you. You have two sets of data which you want to compare. And I want to compare the good Gao clients, I see some of the names go down here with the similar set of clients based out of Google from the table number two. Now I want to apply filter on both these tables simultaneously. So I go ahead and I choose the first table, I go to data and as usual, I apply filter. I go to the second table, I again, choose the data separately, and I'm again going to click on filter, notice the filter buttons from the first table disappears.

Technically speaking, in a normal traditional method, you cannot apply two filters two or more filters simultaneously in the same sheet. So if you ever come across this problem, how do you solve? Let's see, I choose the first table. I go to Insert, and within insert, I noticed this option called table now this was something Introduced specifically from 2007 version of Excel. So you'll find that under the same tab, insert table, I click on table, there's a generic question which says is this the range you're going to talk about and convert into a table. Of course, yes, I do a similar thing for the second table, and truly insert, and I click on table.

Now notice this time, I have two filters on two different tables on the same sheet. And this is what I was referring to. Of course, if you don't like the color, you want to retain the original color, you can go to the Design tab of Table Tools, and from the templates, Table Styles, you can choose the first one, which will strip the entire table of its colors, the one that has been recently applied, as you said, insert table more so if you want to return back to the original form of data range, you can still go to Table Tools design, and you will get something called convert to range. Once you do that, it says Do you want to convert The table to a normal range. Okay, let me test it out. Yes, I do.

So this is like moving back and forth from arrange to a table and from a table to arrange in this video specifically talking about how to apply two or more filters on the same sheet matrix coming up in the upcoming videos.

Sign Up