Hints and tips home » Excel hints and tips » Sorting List Subtotals

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

Added by Pete on 4th March 2007

More Excel hints and tips, like:

• Generate randon numbers
• Use Paint Brush to Format More than one Cell
• Finding your worksheets quickly