| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping just the Sums
Hi,
I have a worksheet that has subtotals. Is there any way to copy just these totals without bringing along the data underneath + ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping just the Sums
Copy the subtotals; when you are ready to paste them select "Paste special"
from the Edit menu and choose "Values." "Novice2000" wrote in message ... Hi, I have a worksheet that has subtotals. Is there any way to copy just these totals without bringing along the data underneath + ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding sums only in certain colored cells | Excel Worksheet Functions | |||
| Fomula for sub sums | Excel Discussion (Misc queries) | |||
| How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
| All 0's for Sums in Pivot Table | Excel Discussion (Misc queries) | |||
| Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
Linear Mode
