subtotal

M

Mark

After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I
copy just the subtotal
 
B

Bernie Deitrick

Mark,

Select the cells, then use Edit / Go to... Special Visible Cells Only, OK, then copy and
paste.

HTH,
Bernie
MS Excel MVP
 

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

Help me Please! Reference cell working w subtotals 2
Using the Subtotal function 2
Nested Subtotals 3
subtotal within subtotal 5
How do I clear a column of data without clearing specific cells? 2
Subtotal To Include Item Description On Subtotal Line 2
subtotal like 5
Formula Help 2

Top