| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I copy an outline w/ subtotals & paste just the subtotals
I have a worksheet with data that has a group and outline in it. The group
and outline rolls up so that the groups contain subtotals. I want to copy the subtotals from the group and outline and paste them into another worksheet with just the subtotals (not with the rest of the rolled up data). I cannot copy and paste just the subtotals, the data expands everytime I paste it. |
|
#2
|
|||
|
|||
|
Use those outlining symbols to show just what you want to copy.
Then select that range edit|goto|special visible cells only copy and paste to the new location. av wrote: I have a worksheet with data that has a group and outline in it. The group and outline rolls up so that the groups contain subtotals. I want to copy the subtotals from the group and outline and paste them into another worksheet with just the subtotals (not with the rest of the rolled up data). I cannot copy and paste just the subtotals, the data expands everytime I paste it. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
| When using subtotals, how do I copy and paste only the subtotals . | Excel Worksheet Functions | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
Linear Mode
