Pasting Subtotal Results

  • Thread starter Thread starter tchen
  • Start date Start date
T

tchen

I have a long worksheet with subtotals. I want to cut and paste th
Subtotal Results only. If you cut and paste, when pasting, it show
everything that was in the subtotal. I just want to paste the resul
of the subtotal. I've tried cut and paste value only, but it doen'
work. Does this make sense? Please Help!!
 
I presume you've collapsed the subtotal outline and want to copy only the
values that are shown, not the hidden rows. To do this highlight the cells
you want to copy and press CTRL+G to bring up the Goto window, click on the
'Special' button at the bottom of the window. Click to put a bullet beside
'Visible cells only'. Now press CTRL+C and you should see the dotted lines
appear around each subtotal, click in the sheet where you want to paste and
press CTRL+V and only the visible cells will be pasted.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com
 

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

Cut/Paste Subtotal Data 2
subtotal copy and paste 3
Copying only subtotals 1
Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
Sorting Subtotals 11
Multiple subtotal rows 1
Help me Please! Reference cell working w subtotals 2

Back
Top