software

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

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:
gt;
gt; I insert subtotals to my worksheet. I want to copy this, meaning just the
gt; subtotals excluding the hidden rows, how do I do this?
gt;
gt; thanks,
gt; del

--

Dave Peterson

thanks. that works.

quot;Dave Petersonquot; wrote:

gt; Use the outlining symbols (to the left) to hide the details (only show the
gt; subtotals).
gt;
gt; Then select what you want to copy
gt; Edit|goto|special
gt; check visible cells only
gt; edit|copy
gt; go to the new sheet
gt; edit|paste
gt;
gt; arcticale wrote:
gt; gt;
gt; gt; I insert subtotals to my worksheet. I want to copy this, meaning just the
gt; gt; subtotals excluding the hidden rows, how do I do this?
gt; gt;
gt; gt; thanks,
gt; gt; del
gt;
gt; --
gt;
gt; Dave Peterson
gt;