Copying subtotals in Excel 2000
 

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

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
EditPaste Special Values

"pearsall" wrote:

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

When copying subtotals, EditPaste Special Values isn't necessary
Using EditPaste is quicker, and has the same result


Duke Carey wrote:
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
EditPaste Special Values

"pearsall" wrote:


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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks for the insight Debra.

Live and learn

"Debra Dalgleish" wrote:

When copying subtotals, EditPaste Special Values isn't necessary
Using EditPaste is quicker, and has the same result


Duke Carey wrote:
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
EditPaste Special Values

"pearsall" wrote:


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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html