| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subtotals
In a spreadsheet, I've used the DataSubtotals 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 |
|
#2
|
|||
|
|||
|
First: EditGoTo...Special..."Visible Cells Only"OK
Then: Copy, PasteSpecialValues (followed by PasteSpecialFormats, if desired) HTH, -- George Nicholson Remove 'Junk' from return address. "Ivor Williams" wrote in message news:6xNJe.144788$%K2.13225@pd7tw1no... In a spreadsheet, I've used the DataSubtotals 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Linear Mode
