| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy a list of Subtotals?
I'm using Excel 2003 and Windows XP Pro.
I'm using a list of accounts that I've sub-totaled by using the buttons in the top left to compress the rows to show only the sub-totals. I want to copy that list of sub-totals and only the sub-total data. Every time I try to copy and paste or paste special, I get all the uncompressed rows. I only want to have the sub-totals as data that I can then manipulate the sub-totals. I hope this question is not too unclear, because I'm really stymied and need help on this!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I copy a list of Subtotals?
Hide the rows you don't want.
select the range edit|goto|special|check visible cells only Edit|copy and edit|paste at the new location. heelfan wrote: I'm using Excel 2003 and Windows XP Pro. I'm using a list of accounts that I've sub-totaled by using the buttons in the top left to compress the rows to show only the sub-totals. I want to copy that list of sub-totals and only the sub-total data. Every time I try to copy and paste or paste special, I get all the uncompressed rows. I only want to have the sub-totals as data that I can then manipulate the sub-totals. I hope this question is not too unclear, because I'm really stymied and need help on this!! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data List | Excel Discussion (Misc queries) | |||
| Copy and Paste Subtotals only. | Excel Discussion (Misc queries) | |||
| List box, copy multiple Cells | Excel Worksheet Functions | |||
| How do I copy Summary totals only from a subtotal list? | Excel Discussion (Misc queries) | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
Linear Mode
