Avoid pasting hidden data

  • Thread starter Thread starter Marcus
  • Start date Start date
M

Marcus

How can I copy a subtotaled worksheet that is collapsed to
the subtotals only and paste it to another worksheet
without all of the hidden data attached?
 
One way:

Make your selection. Choose Edit/Goto/Special and click in the
Visible Cells Only checkbox. Click OK. Copy and paste.
 
Back
Top