Bookmark page
Printable version
Course updates
|
RSS feeds
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:
- Checking formulas with multiple operators
- Separate the year from a date
- removing border lines on the keyboard
 |
|
» Forum post: Formulas |
What is the difference between using = or + at the begining of a formula?
