How do I copy subtotaled data without underlying details in Excel

D

Diletto

I have a large sheet of data that I have subtotaled. I am trying to copy
just the top layer over to a new worksheet. HOwever, it pulls all the data
below the totaled line. What am I doing wrong?

I am on Excel 2007 on Windows XP.
 
S

Shane Devenshire

Hi,

I'm not sure I follow, the Total line usually appears below the data when
you use the Subtotal command?

In general you would apply the subtotal, then collapse the detail, highlight
all the data and press F5, Special, Visible cells only, OK. Then you would
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

How do I copy subtotaled data without the underlying details? 1
New computer, how do i move outlook 365 ENTIRELY? 0
Copying Portions of Data 0
How do I copy Subtotal groups? 1
Excel suddenly crippled by Just-In-Time Debugging 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
How to summarize copied data 2
How do I sort pivot table data by subtotals? 2

Top