| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I copy only sub-totalled values - without any detail?
I am trying to copy only the sub-totalled values (Paste-Values) and eliminate
the detail. How do I just copy the sub-totals? |
|
#2
|
|||
|
|||
|
Hi
- select your range - hit F5, click 'Special' and choose 'only visible cells' - now copy+paste -- Regards Frank Kabel Frankfurt, Germany Parkperson wrote: I am trying to copy only the sub-totalled values (Paste-Values) and eliminate the detail. How do I just copy the sub-totals? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) | |||
| Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Linear Mode
