Once you have applied the filter, you can disable it from that column as shown: The data shows only Active and terminated status and not suspended. When we click on Does not equal to option and write Suspended in the dialogue box as shown below:Īfter we click “Ok”, we will see the data filtered as: Filter cells that are either Equals to or Does not equal to a specific text or characters.Filter cells that Contain or Does not Contain a specific text or character.
Filter cells that Begin with or End with a specific text or character.We get an option for an advanced filter for text, such as: The data is filtered and also got sorted in order of Z to A.īy clicking Sort by color, the data will be filtered as per our criteria and will also be sorted as per color of that cell, like if you select a cell colored red that will be on the top. Likewise, if we click Sort Z to A, we will see the data as below: The data is filtered and got sorted in order of A to Z. If we click on Sort A to Z, this is how we see the data: On top of the filter drop-down, we see an option Sort A to Z then we have Sort Z to A, Sort by color and Text filters. While applying filters on the selected criteria, we see other options as well as shown below: Press OK, and we will see the Active and Terminated agents.If we want to filter the status of the Agents, like Active and Terminated, from the complete data, we will proceed as below:.Select the data and then press the shortcut key to apply the filter, i.e.Here is a sample data on which we have applied the filter using the shortcut key. We can rapidly press a shortcut key to apply the filter in our data. #3 – Filter the Excel data by shortcut key You can disable the filter on the data by clicking on the Sort and Filter option.We will then be able to see the relevant details.Now select Arjit and Dipa Manoj in the filter dropdown and then click on Ok.Now, if we need to filter some particular consumers, like their loan amount and their loan type, suppose we want to know the above details for Arjit and Dipa we will apply the filter as below: You will see the consumers who have taken a car loan. To filter the consumers who have taken a car loan.To apply a filter, click on Sort & Filter, then click on the Filter option, which is the fourth option in the dropdown.Using the above data, here is how we can apply the filter: It can be found on the right side of the Ribbon in MS Excel. #2 – Applying filter using “Sort and Filter” option on the Home tab in the Editing Group You will then be able to filter the data as per your requirement. Now, if we want to see how many consumers have taken a loan of 10000, we can apply the filter as shown below:.To disable Filter, you just need to again click on the Filter in Ribbon in MS Excel.You will see the name of the consumers who have taken Business Growth Loan.Now, if we want to see the name of consumers who have taken Business Growth Loan, we can select Business Growth Loan in the filter drop-down and then click on OK as shown below:.Once we click the Filter tab on the ribbon, we will see that filter is applied to the data, that is, on all the columns.We have to first click on the Data tab and then click on Filter, as shown below.Here is a sample data on which we have to apply a filter.
You can download this Filter Shortcuts Excel Template here – Filter Shortcuts Excel Template #1 – Toggle Autofilter in the ribbon Example #1