Select only visible cells

Select only the visible cells (using different methods) so that you can then: copy only them (for example, only the totals) and paste them onto another sheet format them (apply a fill only to the totals, not to all rows) insert formulas into only these cells—for example, to change the default subtotal headings.