Copying subtotals in Excel 2000

P

pearsall

When I try and copy subtotals to a second sheet all rows are displayed. How
can I copy just the subtotals?
 
D

Duke Carey

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
 
D

Debra Dalgleish

When copying subtotals, Edit>Paste Special> Values isn't necessary
Using Edit>Paste is quicker, and has the same result
 
D

Duke Carey

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...
 
Top