In this article, we will learn how to sort in Excel. Sorting is any process of arranging items systematically in Microsoft Excel and has two common, ...
If you have a range of date, and if you want to filter the data as per year or month, you can do it by using the Format Cells and Auto filter option i...
In this article, we will learn the shortcut to open a filter drop-down list and the filter in Ribbon in Microsoft Excel. “Auto Filter” option all...
To save the criteria while filtering data,, you need to use Custom View in Microsoft Excel. What is Custom View? This tool is used to save the curre...
Whilst using Excel there will be a good number of scenarios where you want to find the number of unique values you have in a range of cells. this co...
In this article, we will learn How to Filter by selected cells in Excel. Scenario: In Excel, Apply Filtering is a simple, however, amazing...
To save filtering criteria, use Custom Views: 1. Filter a List. 2. Select Page layout -> Custom Views (in Sheet Options Group) -> Add. 3. I...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
