Copying Cells in List

I

infinite1013

If i have my cells sorted and subtotaled and close the brackets to show only
the subtotals, is there a way that I can copy only those subtotals without
copying all of the figures that make them up?
 
S

ScottFisher2004

Copy the subtoal cells. Go to where you want the values pasted. Then select
Edit from the menu bar, Paste Special from the drop-down, click 'values', and
select okay.
 
M

Mike H

Hi,

This should work.
Select the range with your subtotals in then

Edit|Goto|Special
Select Visible cells only
Click OK
Copy and paste as you require.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting by Sub-Totals 2
Copying only subtotals 1
subtotals copying 3
how can I print and sort JUST the subtotal lines, not the detail 1
How do I clear a column of data without clearing specific cells? 2
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL 1
subtotal within subtotal 5
Applying formulas only to the subtotals of a data list 5

Top