| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel, how copy subtotals without copying all lines inbetween?
In Excel, once I have used the subtotal function, how can I copy and paste
the subtotals into a new worksheet or new file without also copying all the inbetween lines? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how copy subtotals without copying all lines inbetween?
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 "confounded" wrote: In Excel, once I have used the subtotal function, how can I copy and paste the subtotals into a new worksheet or new file without also copying all the inbetween lines? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Copying Excel object back into Excel from Word | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
| Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
Linear Mode
