Excel: Format the Subtotal Rows

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: My manager loves my reports with automatic subtotals but he wants the entire row in bold, not just the Subtotal By column.

Strategy: Visible Cells Only will again save the day.

  1. Add subtotals to the data set.
  2. Click the 2 Group & Outline button to display only the subtotals.
  3. Select all data except the headings.
  4. Press Ctrl+; to select the visible cells.
  5. Apply Bold. Choose a fill color. Go to a bigger font. Live it up.
  6. Click the 3 Group & Outline button. You've formatted only the total rows.

  1. Format only the subtotal rows.