Filtering by the Date Field in Microsoft Excel

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...

Copying the Subtotals Summary in Microsoft Excel 2010

In this article, we will learn how we can copy the subtotals summary in Microsoft Excel 2010. Subtotal: - This option is used to calculate rows of ...

Creating Subtotals Summary in Microsoft Excel 2010

In this article, we will learn how we can create subtotals summary in Microsoft Excel 2010. Subtotal: - This option is used to calculate rows of re...

Copying or Applying Color to Groups and Outlines in Microsoft Excel 2010

To group and summarize the data, we can create an outline up to eight levels in the data list. To expose the detail for each group, use an outline to ...

Coloring Subtotal Levels in Different Colors in Microsoft Excel

In this article, we will learn how to add subtotals to primary and secondary fields in Microsoft Excel. Subtotal: - This option is used to calculate ...

Adding Subtotals to Primary and Secondary Fields in Microsoft Excel 2010

In this article, we will learn how to add subtotals to primary and secondary fields in Microsoft Excel 2010. Subtotal: - This option is used to cal...

Sorting by Cell Color, Font Color or Cell Icon in Microsoft Excel

Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text ac...

Terms and Conditions of use

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.