| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL
I have a significant amount of data that I have subtotaled in excell. I
would like to copy (and use) the subtotals only in another excell spreadsheet...but when I try to copy and paste I continue to get the detail. How can I copy just "what I see" on the subtotals worksheet ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL
Select all the cells that you want to copy
Choose EditGo to, and click the Special button Select Visible Cells Only, and click OK Choose EditCopy, then paste the cells. BobbyD wrote: I have a significant amount of data that I have subtotaled in excell. I would like to copy (and use) the subtotals only in another excell spreadsheet...but when I try to copy and paste I continue to get the detail. How can I copy just "what I see" on the subtotals worksheet ? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals including blank rows | Excel Discussion (Misc queries) | |||
| Copy Excel Chart (including drawn objects) into Word | Charts and Charting in Excel | |||
| how do i only see subtotals in a pivot and hide the detail | Excel Worksheet Functions | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Pivot table subtotals before detail | Excel Discussion (Misc queries) | |||
Linear Mode
