Subtotals

I

Ivor Williams

In a spreadsheet, I've used the Data>Subtotals menu item and collapsed all
so only the subtotal values are displayed. I would like to copy and paste
only the subtotal values to another location, but when I try to do so, the
details of each subtotal are also copied. Is there a way to copy only the
subtotal values?

Ivor
 
G

George Nicholson

First: Edit>GoTo...>Special...>"Visible Cells Only">OK
Then: Copy, PasteSpecial>Values (followed by PasteSpecial>Formats, if
desired)

HTH,
 

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

Top