Home |
Search |
Today's Posts |
#1
|
|||
|
|||
subtotals copying
i would like to know an easy way to copy the subtotals - from using the
subtotals function - into a new worksheet. You cannot just copy the page because the copy then includes all of the individual lines that you want subtotaled. Currently, the only way i know how to is to hold down the Control key and click each (subtotaled) individual line. This is rough when i have several thousand subtotals to copy. thanks |
#2
|
|||
|
|||
Apply your data|subtotals
Use the outline symbols to just show what you want select that range edit|goto|special|check visible cells only now do copy|paste Dave o wrote: i would like to know an easy way to copy the subtotals - from using the subtotals function - into a new worksheet. You cannot just copy the page because the copy then includes all of the individual lines that you want subtotaled. Currently, the only way i know how to is to hold down the Control key and click each (subtotaled) individual line. This is rough when i have several thousand subtotals to copy. thanks -- Dave Peterson |
#3
|
|||
|
|||
This was TOTALLY helpful - this is a setting i have never used beofre - major
thanks! "Dave Peterson" wrote: Apply your data|subtotals Use the outline symbols to just show what you want select that range edit|goto|special|check visible cells only now do copy|paste Dave o wrote: i would like to know an easy way to copy the subtotals - from using the subtotals function - into a new worksheet. You cannot just copy the page because the copy then includes all of the individual lines that you want subtotaled. Currently, the only way i know how to is to hold down the Control key and click each (subtotaled) individual line. This is rough when i have several thousand subtotals to copy. thanks -- Dave Peterson |
#4
|
|||
|
|||
There are lots of neat options under that Edit|goto|special dialog.
Dave o wrote: This was TOTALLY helpful - this is a setting i have never used beofre - major thanks! "Dave Peterson" wrote: Apply your data|subtotals Use the outline symbols to just show what you want select that range edit|goto|special|check visible cells only now do copy|paste Dave o wrote: i would like to know an easy way to copy the subtotals - from using the subtotals function - into a new worksheet. You cannot just copy the page because the copy then includes all of the individual lines that you want subtotaled. Currently, the only way i know how to is to hold down the Control key and click each (subtotaled) individual line. This is rough when i have several thousand subtotals to copy. thanks -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy subtotals from excel without it also copying the det | Excel Discussion (Misc queries) | |||
copying subtotals in Pivot tables | Excel Worksheet Functions | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Copying subtotals in Excel 2000 | Excel Discussion (Misc queries) | |||
Copying Subtotals? | Excel Discussion (Misc queries) |