Avoid pasting hidden data

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?
 
J

J.E. McGimpsey

One way:

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