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

January 19, 2016

TheExcelAddict.com Quote of the Day

“Happiness is the absence of the striving for happiness.”
-- Chuang Tzu


Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)Thanks to a big snowfall last night, I'm happy to share some more winter pictures with you today. Sunshine and white snow sure make for beautiful scenery. I hope you'll like them. (click the image to the right)

How's the weather 'in your neck of the woods'?

Hope you enjoy today's tip too!

Take care and keep Excelling,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com





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



Excel in Seconds with TheExcelAddict.com

How to Sort Subtotals


If you try to sort data containing subtotals, you will likely get a message that states "This removes the subtotals and sorts again". At first glance you may think that this means it's not possible to sort the data without first removing the subtotals.
 
How To Sort Subtotals in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
However, you need to carefully read the rest of the message, "If you want to sort the subtotaled groups, choose the Cancel button, then collapse the outline and try again." What this is saying is that if you want to sort data that includes subtotals, you first have to collapse the outline so that just the subtotals are visible, then sort the data, then expand the outline.

So, basically, to sort subtotaled data you must first collapse the subtotals.

Collapse Outline To Sort Subtotals in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365


Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week
 '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