ExcelBanter - Keeping just the Sums

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Keeping just the Sums (https://www.excelbanter.com/excel-discussion-misc-queries/127288-keeping-just-sums.html)

Novice2000

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 + ?

Richard O. Neville

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 + ?

All times are GMT +1. The time now is 06:48 PM.