close
In Excel, once I have used the subtotal function, how can I copy and paste
the subtotals into a new worksheet or new file without also copying all the
inbetween lines?
Try this:
Hide the detail rows
Select the range you want to copy
Editgt;Gotogt;
Click the [Special Cells] button
Select: Visible Cells
Editgt;Copy
Go to the destination range
Editgt;Paste Specialgt;Values
Is that what you're looking to do?
***********
Regards,
Ronquot;confoundedquot; wrote:
gt; In Excel, once I have used the subtotal function, how can I copy and paste
gt; the subtotals into a new worksheet or new file without also copying all the
gt; inbetween lines?
全站熱搜
留言列表
