"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

How To Format Your Subtotal Rows To Stand Out


If you use Excel's Subtotals option as much as I do, no doubt you know that the resulting subtotal rows are difficult to distinguish from the surrounding data. To make them stand out you need to change the formatting on these rows.

Here's how you can quickly format all of the subtotal rows at once.

  1. Once you've subtotaled your data you'll notice three Outline Controls (small buttons) on the top left of your worksheet.
  2. Click the '2' button to collapse the outline so only the subtotals are visible.
  3. Select the cells containing the subtotals.
  4. Press the F5 key, click the Special button, select Visible Cells Only
  5. Click OK.
  6. Now that you have just the subtotal rows selected, choose Format, Cells (or press CTRL+1) and apply your desired formatting.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.