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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the Subtotal function 2
Additonal info into newly created Subtotal row 1
Reference cell above in a subtotaled sheet 2
Hidden cells 1
Excel Subtotal 2
How do I copy subtotaled data without the underlying details? 1
Copy subtotals without hidden rows 2
Sequential numbering with Subtotals 3

Top