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
|