5. Click OK. There will be thin white lines above and below each subtotal. If you are in Excel 2007, the color of selected cells is too light to make out the white lines. You’ve now selected only the visible cells.
Figure 652 The white lines indicate the hidden rows are unselected.
6. Press Ctrl+C to copy. The marching ants will surround each row.
Figure 653 Copy the subtotal lines.
7. Switch to a new workbook. Press Ctrl+V to paste. Excel will paste just the subtotal rows.
Figure 654 Paste the subtotals only to a new workbook.
You might think that you would have to select Paste, Values instead of just doing a paste. However, the Paste command works okay. Excel converts the SUBTOTAL functions to values.
Additional Details: Instead of selecting Go To Special, Visible Cells Only, you can press Alt+; (that is, hold down the Alt key and type a semicolon).