Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Is there a quick and easy way to delete all rows that contain subtotal formulas?
    Thanks in advance.

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,172
    Thanks
    47
    Thanked 981 Times in 911 Posts
    How do you define a row as being a subtotal row?

    cheers, Paul

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by P T View Post
    How do you define a row as being a subtotal row?

    cheers, Paul
    If it has a subtotal formula (i. e., "=subtotal(x,y)")

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by jlkirk View Post
    If it has a subtotal formula (i. e., "=subtotal(x,y)")
    I am assuming that you do not want the subtotal rows
    simply click on Data on the menu bar
    select Subtotals
    click on Remove All

    This will remove all subtotals and grand total.
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by franciz View Post
    I am assuming that you do not want the subtotal rows
    simply click on Data on the menu bar
    select Subtotals
    click on Remove All

    This will remove all subtotals and grand total.
    Thanks.

Posting Permissions

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