FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week
Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365


July 5, 2016

Hi fellow Excel Addict,

Francis Hayes - TheExcelAddict.comThanks to everyone who wished me luck for the Kelligrews Soiree 8K race last Saturday. It was a perfect morning for running...cool and no wind. I've run this same race three times in the past five years and this year I had a personal best time of 39:05.

Now I've got two weeks to prepare for the Tely 10. This is the race I was training for in 2014 when I injured my knee. If all goes well, this will be my first Tely since 2013. I've already run 12K a couple of times in the past month, so I think I'm almost ready.

I hope you'll find today's tip on quickly formatting subtotal rows helpful. Please feel free to share it with anyone you think could use a little more Excel smarts.

If you missed last Thursday's Excel in Minutes' tip, 'Quickly Merge Multiple Ranges of Cells Across Or Down', you can read it here now.

Wishing you a great week end keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com




TheExcelAddict.com Quote of the Day

"Finish each day and be done with it. You have done what you could;
some blunders and absurdities have crept in; forget them as soon as you can.
Tomorrow is a new day; you shall begin it serenely and with too
high a spirit to be encumbered with your old nonsense."

-- Ralph Waldo Emerson --



If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

Make Your Subtotal Rows REALLY Stand Out

When you insert subtotals (Data, Subtotal) in a list, it is difficult to distinguish the subtotal rows from all the other rows in the list.
 

Subtotal Rows Don'T Stand Out in Microsoft Excel 2007 2010 2013 2016 365
Here's a quick way to make them REALLY stand out.


1) Once your data has been subtotaled, click the small outline button (2) on the top left corner of your worksheet to collapse your list and show only the subtotals.

Show Only Subtotal Rows in Microsoft Excel 2007 2010 2013 2016 365

2) Drag to highlight your subtotal rows. Even though the data rows are not visible, they are still included with the cells you have selected;

3) To select only the visible (unhidden) cells, hold down the Alt key and press the semicolon (;) key (i.e. ALT+;);

Select Only Visible Subtotal Rows in Microsoft Excel 2007 2010 2013 2016 365

4) Now that only the cells in the subtotal rows are selected, make them stand out by changing any of their formatting such as fill, font, borders, row height, vertical alignment, etc... If you add a top border to your subtotal rows, you will also need to add Inside Horizontal borders as well to account for the Grand Total row which is immediately below the last subtotal and therefore doesn't have a top border;

Select Only Visible Subtotal Rows in Microsoft Excel 2007 2010 2013 2016 365
4) Finally, click the Outline 3 button to show all of your data.

Make Subtotal Rows Really Stand Out in Microsoft Excel 2007 2010 2013 2016 365
Now, doesn't that looks much better?

You can see that the formatting has been applied only to the subtotal rows.

Remember that if you remove the subtotals, the formatting will be lost when the subtotal rows are removed and you will need to apply it again.

If the Outline controls are not visible on your screen, click the FileOptions and click the Advanced tab. Scroll down to 'Display options for this worksheet' and check the option for 'Show outline symbols if an outline is applied'.



FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630