"How To Excel" Mini-Tutorials|
"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.
- Once you've subtotaled your data you'll notice three Outline Controls (small buttons) on the top left of your worksheet.
- Click the '2' button to collapse the outline so only the subtotals are visible.
- Select the cells containing the subtotals.
- Press the F5 key, click the Special button, select Visible Cells Only
- Click OK.
- 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)