copy the result of a subtotal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to copy the result of a subtotal in a sheet without the data. I
cannot find the function Copy visible cells only.

Lost....
 
Hi Angela

If you have used Data>Subtotals then click on 2 to show only the Subtotals

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Press Alt ; to select all visible data or use F5>Special>Visible cells only>OK
4) Ctrl c or Edit>Copy
5) Insert>Worksheet
6) Ctrl v or Edit>Paste
7) Select the sheet with the Subtotals
8) Press Esc
 
Back
Top