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

Similar Threads

Using the Subtotal function 2
Copying Subtotals to new worksheet 2
Additonal info into newly created Subtotal row 1
Subtotals and Conditional Formatting 1
Subtotalling 1
Autofilter and Subtotals 1
summing subtotals 1
Subtotals copy paste 1

Top