» Applying Styles to Subtotal Rows
CATEGORY - Excel Subtotals
VERSION - All Microsoft Excel Versions
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.



Book Store:
Recommended Books:
- Analysis of Financial Statements
- Marketing Management
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- The Basics of Finance: Financial Tools for Non Financial Managers
- Microsoft PowerPoint Version 2002 Step by Step
- Investments + S&P Card + Powerweb + StockTrak discount coupon
No comments have been submitted.

