January 19, 2016
Hi fellow Excel Addict,
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)
If you missed my last newsletter, you can click here to view it online.
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.
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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630