| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotals
I have a very large spreadsheet for which I have created subtotals. How can
I copy only the totals without all the detail to another spreadsheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotals
Minimize the subtotals using the minus buttons to the left, once you have it
as you want, select the whole visible range that you want, press F5, click special and select visible cells only, click OK and copy and paste it -- Regards, Peo Sjoblom "MLShef" wrote in message ... I have a very large spreadsheet for which I have created subtotals. How can I copy only the totals without all the detail to another spreadsheet? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotals
thank you so very much. that will be very helpful
"MLShef" wrote: I have a very large spreadsheet for which I have created subtotals. How can I copy only the totals without all the detail to another spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
