Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: How to display only subtotals

    When using the subtotal function in excel, is there a way to display only the subtotals? There seems to be no option for this in the menu, so if I have 10,000 records, I see my subtotals dispersed between the different categories. To use the subtotals, I then need to go thru a sorting process, copy/paste special just the subtotals to a new worksheet, then unsort the original subtotaled worksheet and remove its sub-totals.

    There must be a better way.....

  2. #2
    Join Date
    Jan 2003
    if you are NOT using AutoFilter to filter the list before doing the subtotal function, after subtotal function finishes, on the left hand side of the screen, right under the cell address window there are 3 small boxes with number 1,2,3. click on number 2 you will see the subtotals only

    hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts