Shrink the range with the minus buttons so you only see the subtotals, select
the range, press F5 and select visible cells only, copy and paste


Regards,

Peo Sjoblom

"mmiazga" wrote:

When I have a spreadsheet with subtotals, sometimes I just want to copy the
subtotals into another sheet and forget about what is being summed to give me
the subtotal. How do I copy and paste only the subtotals.