MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Remove subtotal problem

Posted by A.R. on January 23, 2002 8:38 AM

I received a large Excel worksheet that includes subtotal data. I need to copy this data to another worksheet showing all the data lined up without the subtotal and blank rows. I tried the “Subtotal – Remove All” feature but that didn’t work. What I can do is manually delete the subtotals one by one by but that is time consuming. Any advise, tips? Thanks.

Posted by If you haven't already - Adam S. (-nt) on January 23, 2002 8:56 AM

"remove all" should do it...try Ctrl+A then Subtotal-remove all