| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy subtotals without hidden rows
How do I copy/paste subtotaled data without also copying the detail (hidden
rows)? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy subtotals without hidden rows
Select the range, press F5, click special and select visible cells only,
click OK, copy and paste -- Regards, Peo Sjoblom "bfordmelson" wrote in message ... How do I copy/paste subtotaled data without also copying the detail (hidden rows)? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy subtotals without hidden rows
Try this:
Hide the detail rows Select the range you want to copy EditGoto Click the [Special Cells] button Select: Visible Cells EditCopy Go to the destination range EditPaste SpecialValues Is that what you're looking to do? *********** Regards, Ron "bfordmelson" wrote: How do I copy/paste subtotaled data without also copying the detail (hidden rows)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display hidden rows maybe defined by scenario | Excel Worksheet Functions | |||
| Did I stump everyone? Counter that ignores hidden rows | Excel Discussion (Misc queries) | |||
| inset rows and copy formatting , excel macro | Excel Discussion (Misc queries) | |||
| How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
Linear Mode
