How do you copy & paste the subtotal amount only?

J

jmaxwell

I am trying to copy a column of subtotal and paste without
the data that makes up the subtotal. I have tried the
special paste values only but excel continues to copy all
the underlying data.

Help would be greatly appreciated.

Thank you
 
A

Anders S

Hi,

Try Edit>Goto>Special>Visible cells, then copy & paste normally.

HTH
Anders Silven
 

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

How to paste this down? 3
Embed the same Excel multiple times 0
Pages are changing pasted image... 0
How to make repeating drop-down lists? 2
Paste to excel from word - auto format problem 1
Getting Text data using the Data - Subtotal feature 1
Copying only subtotals 1
I need ONLY subtotals copied to a second sheet 4

Top