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