| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy subtotals
After I collapse the grouping on a mult-thousand row table I am left
with about 30 subtotaled rows of totals. How can I copy just the subtotals without copying any of the rows in between? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy subtotals
collapse the data
Select the range to copy Edit|goto|special|Click visible cells only Edit|copy to the destination cell edit|paste special|values ExcelMan wrote: After I collapse the grouping on a mult-thousand row table I am left with about 30 subtotaled rows of totals. How can I copy just the subtotals without copying any of the rows in between? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a list of Subtotals? | Excel Discussion (Misc queries) | |||
| Copy subtotals | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| When using subtotals, how do I copy and paste only the subtotals . | Excel Worksheet Functions | |||
| Copy/paste Subtotals | Excel Worksheet Functions | |||
Linear Mode
