D Debra Dalgleish Jan 3, 2004 #2 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.
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.