The filter feature in Excel is one of the most frequently used features. We will now introduce two smart tips when using this feature.
When you have a bunch of data in a worksheet, you will certainly need to analyze the data and information. One of the methods to analyze is using the filter feature. But thus feature also contains many details that most if you may ignore. In order to help you use filter better, we have the two tips. You can continue reading the following parts.
Tip 1: Use Sort Feature in Filter
Actually, when you use the filter feature, you can also use the sort feature.
- Click a cell within the target range that you need to filter.
- And then click the button “Sort & Filter” in the toolbar.
- After that, click the option “Filter” in the drop-down list. Thus, you will see small arrow in the head row of the target range.
- Click the small arrow in the head cell of target column, you can see many different options. And there are three options about sort. Here you can also sort this column by certain criteria.
This is very convenient for your work.
However, here lies the key point. When you sort this column, have you filtered it or not? The different order will cause different result. There are two conditions.
Condition 1: Sort->Filter
In this condition, you will first sort the column and then filter it.
- Sort the column with a certain criterion. Here we will use “Smallest to Largest”.
- And then filter the column with another criterion. We will use this condition: greater than 360. And then you can view the result in the worksheet.
- When you clear the criterion of filter, the result of sort will remain in the range.
By using this order, there is nothing different.
Condition 2: Filter->Sort
However, when you change the order, things will be different.
- Filter the column with a certain criterion.
- And then sort this range.
For the above two steps, we will apply the same criteria as the first condition. The result of the filter and sort is the same as the previous condition.
- Next you need to clear filter. At this time, when all the data are shown in the range, you will see a different order.
This is because the sore feature will only take effect on the result of the filtered cell in the range. Other cells will remain in the original condition. The difference is caused by the different order of using the two features. The next time when you need to use them in the same column, you need to pay attention to the order.
Tip 2: Reapply Filter
In this part, we will introduce another useful tip. When you add new data into a range, you will need to filter this column again. Clicking the small button in a cell and set the criteria all over again will cost you a lot of time. Therefore, you can use the reapply feature in filter. In the image below, there are new data in the color green.
Follow the steps and see how to use the reapply.
- Click the button “Sort & Filter” in the ribbon.
- And then choose the option “Reapply”. You will see the result appear in the worksheet immediately.
Next time don’t perform the long process and set the criteria again. The reapply feature can certainly satisfy your needs.
The above are the two intelligent features about the filter feature. With the deeper understanding of it, you can analyze your data better.
Recover Corrupted Excel Workbooks
Those Excel workbooks in your computer are certainly very important to you. When they corrupt, you need to repair them as soon as possible. Now, you can use a third-party tool to repair damaged xlsx data. With this tool at hand, you can get back all the lost data in an even severely damaged Excel file.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair Word docx data corruption and outlook repair software products. For more information visit www.datanumen.com