Tip Printed from ExcelTip.com

---

Applying Styles to Subtotal Rows in Excel 2007


To apply styles to subtotal levels:

1. Add subtotals to the List.
2. Select a cell in the List, and press Ctrl+Shift+* or press Ctrl+A to select the List.
3. Select Data -> click Dialog Box Launcher in the bottom-right corner of
Outline Group -> Apply Style (in Settings dialog box).