Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy Summary totals only from a subtotal list?
I remember reading there is a way of copying only the summary totals from a
Subtotalled list that has only the summary totals (subtotals) showing. I cannot remember the method / keystrokes however. Using CTRL+C or EditCopy copies the underlying data also- and I have pages of that I want to leave behind. Does anyone know how I do this please? Thanks in anticipation, Dominic |
#2
|
|||
|
|||
Hi
Try edit goto special visible cells only "Dominic" wrote: I remember reading there is a way of copying only the summary totals from a Subtotalled list that has only the summary totals (subtotals) showing. I cannot remember the method / keystrokes however. Using CTRL+C or EditCopy copies the underlying data also- and I have pages of that I want to leave behind. Does anyone know how I do this please? Thanks in anticipation, Dominic |
#3
|
|||
|
|||
Hi Dominic-
Try it this way, Ctrl+Click the cells containing the Subtotals, then Copy & Paste. Make sure to Ctrl+Click each cell, don't drag because you'll get an error when you try to Copy. Hope this is useful |:) "Dominic" wrote: I remember reading there is a way of copying only the summary totals from a Subtotalled list that has only the summary totals (subtotals) showing. I cannot remember the method / keystrokes however. Using CTRL+C or EditCopy copies the underlying data also- and I have pages of that I want to leave behind. Does anyone know how I do this please? Thanks in anticipation, Dominic |
#4
|
|||
|
|||
Thank you To Tina & CyberTaz for the responses. Tina's worked perfectly,
thank you very much for your help. Dominic. "tina" wrote: Hi Try edit goto special visible cells only "Dominic" wrote: I remember reading there is a way of copying only the summary totals from a Subtotalled list that has only the summary totals (subtotals) showing. I cannot remember the method / keystrokes however. Using CTRL+C or EditCopy copies the underlying data also- and I have pages of that I want to leave behind. Does anyone know how I do this please? Thanks in anticipation, Dominic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy subtotal information to new sheet | Excel Worksheet Functions | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |