How do I copy subtotaled data without underlying details in Excel

  • Thread starter Thread starter Diletto
  • Start date Start date
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.
 
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.
 
Back
Top