Copying subtotals in Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try and copy subtotals to a second sheet all rows are displayed. How
can I copy just the subtotals?
 
Display only the subtotal rows
Select the entire range
Press the F5 key and click on Special
Check 'Visible cells only'
Click on OK
Copy
Go to your other sheet
Edit>Paste Special> Values
 
When copying subtotals, Edit>Paste Special> Values isn't necessary
Using Edit>Paste is quicker, and has the same result
 
Thanks for the insight Debra.

Live and learn

Debra Dalgleish said:
When copying subtotals, Edit>Paste Special> Values isn't necessary
Using Edit>Paste is quicker, and has the same result
Click to expand...
 
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

Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
subtotal copy and paste 3
Copying only subtotals 1
Copy within a subtotal 1
To copy subtotal into another sheet 3
subtotal titles 1
Subtotal placement issue 2

Back
Top