Copying Cells in List

  • Thread starter Thread starter infinite1013
  • Start date Start date
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?
 
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.
 
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
 
You must log in or register to reply here.

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

Copying only subtotals 1
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
subtotal titles 1
subtotal copy and paste 3
Sorting and subtotal in a filtered list 1
Help me Please! Reference cell working w subtotals 2
Copy within a subtotal 1

Back
Top