copy visble cells at the subtotal level

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to copy just the visible cells after I have subtotaled, it pastes
all the details even when I paste special (just values). SOmeone told me
there is a view/copy visible cells icon but I can't find it.
Thank you
 
To find the icon, go into the Customize Toolbars menu. On the commands tab,
pick Edit. Way at the bottom is an icon that looks like four black boxes
stacked together that says "Select Visible Cells." Add that to one of your
toolbars. Then, once you've higlighted the subtotal rows, hit the new
button, then copy. When you paste values, it should remove the details.
 
Try F5>Special>Visible cells only and OK.

The button/icon is located in Tools>Customize>Commands>Edit.

Scroll down to the bottom to find it.

Move it up to your Toolbar if you wish.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in subtotal worksheets? 3
Paste Special Values 2
Subtotals copy paste 1
subtotal copy and paste 3
copy visible cells 1
Subtotal of values in cells containing formula 1
To clear visable cells in a subtotal - can it be done? 2
Subtotal 3

Back
Top