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

    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
    Location
    Vietnam
    Posts
    188
    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
    qha_vn

Posting Permissions

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