copying and pasting with hidden rows
 

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

copying and pasting with hidden rows
 

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

arcticale wrote:

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

--

Dave Peterson

copying and pasting with hidden rows
 

thanks. that works.

"Dave Peterson" wrote:

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

arcticale wrote:

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

--

Dave Peterson