| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Hello,
I should like to copy only the result of the subtotals (position 2) How can it be done? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotals
After you used data|subtotals?
Hide the details select the range to copy edit|goto|special|visible cells only edit|copy And then paste where you want. zekni wrote: Hello, I should like to copy only the result of the subtotals (position 2) How can it be done? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotals
You can use the Alt+; shortcut for selecting visible cells before
copying. On 2 Mar, 13:41, "zekni" wrote: Hello, I should like to copy only the result of the subtotals (position 2) How can it be done? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| Subtotals adding a description next to the subtotals | Excel Worksheet Functions | |||
| 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) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Hybrid Mode
