Geekers - – Microsoft Excel is one of the applications from Microsoft that is most often used to create reports, assignments and so on.
There are lots of features provided by Microsoft Excel itself, one of which is the Filter feature or often referred to as autofilter, which is a feature in Microsoft Office Excel that is used to display certain rows of data according to the filters we apply and hide the remaining rows of other data. With this feature, it can make it easier for us as users to make reports or assignments.
But, maybe there are still many of us who don't know about this feature, especially for novice users. For those of us who don't know, for sure we will filter the data manually, so it will take quite a long time. So, we better take advantage of the filter feature. Then, how do you filter data in a range or table in Excel?
Well, this time I will share about how to filter data in a range or table in Ms. Excel very easily. how do? Just follow the steps below.
How to Filter Data in Range or Table
In this tutorial I use Microsoft Excel version 2013, but if you use another version that's fine too. Because the steps taken will not be much different. Immediately, see the steps - the following steps.
1. First, make sure you already have some data ready to be filtered. As in the picture below.
table data table data
2. Then, please go to the Data menu at the top. As in the picture below.
click data click data
3. Then, please click "Filter". As in the picture below.
click filter click filter
4. Then, a triangular icon will appear in each column. As in the picture below. Please click which column you want to use as a reference for filtering. For example, you only want to display the number of items between 2 and 5. So, please click the triangle icon in the Quantity column. As in the picture below.
how to filter data in a range or table in Ms. Excel how to filter data in a range or table in Ms. Excel
5. Then, please click "Number Filters". Then, on the next menu, please select what you want. For example, between if you want to display the number between. As in the picture below.
number filters number filters
6. Then, please enter the number you want, then click Ok. As in the picture below.
select amount select amount
7. So, only your table data will appear which has a number of items between 2 to 5. As shown in the image below.
result result
8. You can also display based on filter text. Please select the column you want. For example the item column. As in the picture below.
how to filter data in a range or table in Ms. Excel how to filter data in a range or table in Ms. Excel
9. Then, please select "Text Filters". Then, on the next menu, please select what you want. Which filter do you want.
text filters text filters
10. Then, please select the name of the item you want to display, then please click Ok. As in the picture below.
select item select item
11. Then, data will appear that has the appropriate name that you entered earlier. As in the picture below.
how to filter data in a range or table in Ms. Excel how to filter data in a range or table in Ms. Excel
Well, how? The method is quite easy and very simple, right? Now we can filter or filter data in our table very easily. So, it's easier for us to find or display the data in the table we want.
That's how to filter data in a range or table in Ms. Excel easily that you can try. If this article can help you, please share it with your friends so they also know how to filter data in a range or table in Ms. Excel. Hopefully this article can be useful for all of us. If there is a writing error please forgive. Thank you 🙂
RELATED TUTORIALS
* How to Set Storage Duration in Microsoft Excel
* How to Hide Worksheets in Microsoft Excel
* Tutorial on how to make barcodes in Microsoft Excel
* How to Print an Excel Sheet with Landscape