Excel User Tips

Return to The Spreadsheet Page

Excel page

User tips

 - Charts

 - Formula

 - Formatting

 - Printing

 - Miscellaneous

Help resources


Change the formatting of your subtotal rows

Excel's Data, Subtotals command inserts subtotal formulas into a list. This is a very useful command, but it's often difficult to identify the subtotal rows.

You may want to make the subtotal rows stand out by applying special formatting. However, this can't be done by any of Excel's autoformats. Use the outline controls on the left side of the workbook to collapse the outline so only the subtotal rows are visible. Press F5, select Visible Cells Only, and click OK. Then apply formatting to the selected cells.

When you expand the outline, only the subtotal rows will have the formatting you applied.