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

Vlookup a subtotal 2
Problem with subtotal function 0
Additonal info into newly created Subtotal row 1
Subtotal of adjacent coloumn 4
Can I use the subtotal function while a worksheet is protected? 0
Excel 2007 - Outline not displaying all nested subtotals 0
Does Excel have a @grandtotal function like Lotus 123 2
subtotal, match? 10

Top