Copying information from a Group

J

Janet

I am working in Excel 2000 and I have a group/outline information on a spreadsheet and want to copy the subtotals and totals only into another sheet. Is this possible?
 
D

Debra Dalgleish

Collapse the list so that only the subtotals and totals are visible.
Select the cells that you want to copy
Choose Edit>Go To, click Special
Select 'Visible cells', click OK
Choose Edit>Copy
Select a cell, and choose Edit>Paste.
 
B

Bob Cresto

Select the group then Ctrl G>Special>Visible cells only>OK. Then copy and
paste and only the subtotals and total, not the underlying data, will
appear.


Janet said:
I am working in Excel 2000 and I have a group/outline information on a
Click to expand...
spreadsheet and want to copy the subtotals and totals only into another
sheet. Is this possible?
 
Top