Hi
if you're talking about the situation where if rows are hidden (through the
data / subtotals function) when you select just the subtotals and copy &
paste them onto another sheet all the hidden rows come too, if so:
collapse the outline so only the subtotals are visible
select the area containing the subtotals and then choose
edit / goto and click the special button
choose visible cells only and click OK
now copy & paste as normal
Cheers
JulieD
"mmiazga" wrote in message
...
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.
|