| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Paste Subtotals Only
I use the Subtotals command from the Tools Menu and then use the Outline Bar
to collapse my list so that only the subtotals and grand totals are displayed. I then want to be able to copy only that information. If I copy and paste I get all the intervening rows and if I copy and paste special only values I still get all the intervening rows. Is there a way to do this? I am using 2003 |
|
#2
|
|||
|
|||
|
After you've collapsed the range, hit Edit|Goto and click Visible cells only.
Then copy|paste. Mary Ann wrote: I use the Subtotals command from the Tools Menu and then use the Outline Bar to collapse my list so that only the subtotals and grand totals are displayed. I then want to be able to copy only that information. If I copy and paste I get all the intervening rows and if I copy and paste special only values I still get all the intervening rows. Is there a way to do this? I am using 2003 -- Dave Peterson |
|
#3
|
|||
|
|||
|
Fabulous - works a treat.
"Dave Peterson" wrote: After you've collapsed the range, hit Edit|Goto and click Visible cells only. Then copy|paste. Mary Ann wrote: I use the Subtotals command from the Tools Menu and then use the Outline Bar to collapse my list so that only the subtotals and grand totals are displayed. I then want to be able to copy only that information. If I copy and paste I get all the intervening rows and if I copy and paste special only values I still get all the intervening rows. Is there a way to do this? I am using 2003 -- 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) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | 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) | |||
| PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT | Excel Discussion (Misc queries) | |||
Linear Mode
