Excel Filter: How to Filter in Excel - Amazing Guide

Function of Excel filter is just amazing, using a filter data means to set conditions. When it comes to filtering a data Excel gives us many options. In short term we can say that filter is used to focus on the specific information in Worksheet. And keep in mind that filtering will not remove or modify the data it will just help to evaluate the desired information. Do you want to know how to add Filter in Excel? If yes then continue to read below we are introducing amazing solutions to create filters.

Solutions on How to Filter Data in Excel

Option 1. How to Add Filter in Excel

Step 1: Open Excel sheet and select data for which you want to set Filter.

Step 2: In the second step you need to choose Data and then Sort and Filter and then Filter.

Step 3: Choose drop-down arrow for the column you want to set filter.

Step 4: If you are confused then you can have a look to the picture below

filter

Step 5: Now you need to choose Number Filters or Text Filters. It's up to you which one you choose.

Step 6: In fourth step you need to choose the comparison Operator

Step 7: After that, a dialogue box will appear where you can set the criteria.

criteria

Step 8: At the end just choose the OK button to proceed.

We have introduced an amazing solution how to filter in Excel now let's have look to more functions of Filter.

Option 2. How to Create Filter in Excel by Color

Step 1: First you need to choose cell that contains cell color.

Step 2: After selecting cell, on the Data Tab choose Filter.

Step 3: Now you need to choose the Arrow for which you want to set Filter.

Step 4: Under Filter choose By Color and choose Cell Color at the end choose criteria.

After setting criteria choose Ok to proceed to set Filter. Its same like setting Filter for numbers or text here you just need to choose By color.

Option 3. How to Filter in Excel for Specific Text

 Step 1: First you need to choose cell for which you want to set filter.

Step 2: After selecting cell, on the Data Tab choose Filter and choose By Text.

Step 3: Now you need to choose the Arrow for which you want to set Filter.

Step 4: In fourth step you need to choose the comparison Operator

Step 5: After that, a dialogue box will appear where you can set the criteria

Step 6. At the End choose Ok to proceed.

Option 4. How to Filter Data in Excel using number

Setting Filter using numbers is same like we set filter for a specific text.

Follow all above steps for setting Filter using numbers. Just choose By numbers instead of By Text and then proceed next steps all like we did for setting Filter for specific text.

If you want to know how to use advanced Filter in Excel then read below.

Option 5. How to Use Advanced Filter in Excel

As you have seen above how to create filter in Excel is so simple let's have a look to use Advanced Filter in Excel.

Step 1: Choose any data cell in the sheet

Step 2: First choose Data Tab and then choose Sort & Filter Group

Step 3: Now you can choose Advanced Filter from there.

Extra Tips: How to Recover Forgotten Excel Password

Are you looking for an amazing tool to recover forgotten Excel password? If yes then we will strongly recommend you to try PassFab for Excel, this tool is just awesome and reliable. We are pretty much sure that you will be glad to use it. According to Expert observation this tool is free of viruses and helps a lot to recover any Excel password so why not to use it?

Step by Step guide to use this Excel password recovery tool:

Step 1. First download PassFab for Excel if you have done with downloading install it.

Step 2. Choose Add button and import the protected file.

excel password recovery

Step 3. Now you will be able to choose one of the three Attack Types.

First one is Dictionary Attack. For more success rate you can choose your own dictionary too by going to settings.

Second Attack type is Brute Force with Mask. If you will select this one then you can set different parameters like symbols or letters etc for making recovery process strong. You can customize numbers by choosing Settings.

Third Attack type is Brute Force. This one is best of all because this option tries all possible combinations but it will takes more time. If you are not in hurry then you can select this one.

attack mode

Step 4. After you have done with Attack type selection just choose Start button if you want to proceed the recovery process.Finally your password has been recovered.

find excel password

Here is a video tutorial on how to use PassFab for Excel:

Summary

The short story of this article is that, today you have learnt how to filter data in Excel, function of filters, How to filter for specific text, etc. Well you can see above that we have introduced amazing solutions on it that even a kindergarten student can done all these steps easily and can get benefit by using Filters. We have also introduced an amazing solution for those who are looking for Excel password recovery tool. If you like this article and want to get in touch with latest informative articles then subscribe our Newsletter. Share this article with others too.

Updated on / Posted by Andy Samuel to Excel Tips / Follow @Andy Samuel

Comment

Product-related questions? Speak directly to our Support Team >>