| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut/Paste Subtotal Data
I need to cut and paste the result of data that's been subtotaled. After
hitting #2 and cutting the data, when I try to paste it, the entire data is pasted and not just the subtotal results. Is there a way to cut/copy and paste only the subtotal's? Many thanks if you can help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cut/Paste Subtotal Data
Stan,
Hide the subtotal details so that only what you want to copy is visible. Then select the range of cells you want to copy, press F5 then press Alt^S to bring up the 'Go To Special' dialog box, then select 'Visible cells only'. Now copy the data, go to where you want the summary data and paste what you copied. You should note that this will only produce static values based on the subtotals at the time you copy them, so if the underlying data changes your copied values will not update automatically. HTH, TK "Stan" wrote: I need to cut and paste the result of data that's been subtotaled. After hitting #2 and cutting the data, when I try to paste it, the entire data is pasted and not just the subtotal results. Is there a way to cut/copy and paste only the subtotal's? Many thanks if you can help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cut/Paste Subtotal Data
Many thanks! I would have never figured that out. I really appreciate the
asssistance! "T Kirtley" wrote: Stan, Hide the subtotal details so that only what you want to copy is visible. Then select the range of cells you want to copy, press F5 then press Alt^S to bring up the 'Go To Special' dialog box, then select 'Visible cells only'. Now copy the data, go to where you want the summary data and paste what you copied. You should note that this will only produce static values based on the subtotals at the time you copy them, so if the underlying data changes your copied values will not update automatically. HTH, TK "Stan" wrote: I need to cut and paste the result of data that's been subtotaled. After hitting #2 and cutting the data, when I try to paste it, the entire data is pasted and not just the subtotal results. Is there a way to cut/copy and paste only the subtotal's? Many thanks if you can help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtotal copy-paste and delete hidden rows | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| paste only subtotals, not individual date that makes up subtotal | Excel Worksheet Functions | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| cut and paste subtotal from excel | Excel Worksheet Functions | |||
Linear Mode
