Applying Styles to Subtotal Rows

To apply styles to subtotal levels:

1. Add Subtotals to the List.
2. Select a cell in the List area, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the List.
3. From the Data menu, select Group and Outline, and then Settings.
4. Click Apply Styles. The automatic style is applied to Subtotal lines level 2.

To modify the automatic style:

1. From the Format menu, select Style.
2. From Style name in the Style dialog box, select RowLevel2 (the style RowLevel2 & RowLevel1 are automatically created upon clicking Apply Styles, as described above).
3. Click Modify, and select any desired format.
Screenshot // Applying Styles to Subtotal Rows
Applying Styles to Subtotal RowsApplying Styles to Subtotal RowsApplying Styles to Subtotal Rows

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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