Coloring Two Subtotal Levels in Different Colors

Option 1: Permanent Coloring To color each level in a different color by coloring visible cells: 1. Add Subtotals with two totaling levels 2. C...

Applying Colors to Subtotal Rows

Option 1: Permanent Colors To apply colors to subtotal rows: 1. Add Subtotals to the List. 2. Click Level 2 of the Subtotal levels. 3. Select ...

Copying the Subtotals Summary

To copy the subtotals summary: 1. Add Subtotals to the List. 2. In the Subtotal levels, click level 2. 3. Select a cell in the List, and press Ct...

Printing Each Subtotal Group on a Separate Page

CATEGORY - Excel Subtotals VERSION - All Microsoft Excel Versions To print each subtotal group on a different page: In the Subtotals dialog box,...

Adding Subtotals to a Date Field

To add subtotals to a date field in a List: 1. Copy the Date column and insert it twice. 2. Change the titles for the two new columns to Month and...

Adding Additional Functions to Subtotals

To add additional functions to subtotals: 1.Add Subtotals to the List. OR 2.From the Data menu, select Subtotal. 3. From Use function, selec...

Adding Subtotals to Primary and Secondary Fields

To add subtotals to primary and secondary fields: 1. Sort, in ascending order, the field for which you want to have the secondary subtotal. In this...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube