copying and pasting with hidden rows

A

arcticale

I insert subtotals to my worksheet. I want to copy this, meaning just the
subtotals excluding the hidden rows, how do I do this?

thanks,
del
 
D

Dave Peterson

Use the outlining symbols (to the left) to hide the details (only show the
subtotals).

Then select what you want to copy
Edit|goto|special
check visible cells only
edit|copy
go to the new sheet
edit|paste
 
A

arcticale

thanks. that works.

Dave Peterson said:
Use the outlining symbols (to the left) to hide the details (only show the
subtotals).

Then select what you want to copy
Edit|goto|special
check visible cells only
edit|copy
go to the new sheet
edit|paste
Click to expand...
 
Top