How to use Filter in Excel 2010?
What do you know about Excel 2010? It is basically a place where you can store over a million rows of data. But, don’t you think finding about one particular data within those million rows would become difficult, making your Excel experience quite frustrating? Knowing all the tips, tricks and tools of the Excel 2010 filters can help you find that needle in the haystack.
With Excel 2010 filter, you can easily get a little more specific with your criteria and identify any particular data of the records. Â AutoFilter allows you to hide data based on specific criteria within each column.
Here are the steps that will guide you how to use Filter in Excel 2010. See how it goes:
- In order to activate the basic Excel filter, select the Data tab at the top of your spreadsheet and then select the Filter option.
- It displays the drop-down menus on each of your header cells, which can be used to select the rows to be displayed.
- Open the drop down menu and go to ‘Filter by color’ and you can select the color you want from the list. This may be text color or the color of a cell background.
- You can also filter your data by using Number Filters like:
- Greater Than: Displays the numerical values that are greater than the chosen value.
- Less Than: Displays the numerical values that are less than the chosen value.
- Between: Displays the numerical values that lie between the chosen values.
- Top 10: Displays rows containing the top selected values.
- Above Average: Display numerical values that are above the average value
- Below Average: Display numerical values that are below the average value
So, this is how you can add and use filter in Excel 2010. Weren’t the steps easy to follow? You can simplify your data with simple AutoFilter option in the Microsoft Excel.Â To comprehend the above-mentioned steps in a better manner, you can go through our video solution that is given below.