Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Deleting rows with subtotal amounts

Posted by A.R. on December 04, 2001 7:23 AM

I received several worksheets that show the subtotal amounts. I need the data to be displayed without the subtotal amount. There are 7 to 8 subtotal amounts displayed every 5th –6th rows and I delete the rows with subtotal amounts one by one. Is there a quick way to delete the rows with subtotal amounts all at once?

Re: Deleting rows with subtotal amounts

Posted by Mike on December 04, 2001 7:38 AM

Click data/subtotals/remove all!

For Mark

Posted by A.R. on December 04, 2001 8:15 AM

Mark,

I tried the "data/subtotals/remove all" function but that didn’t work. It still shows the subtotal amount. Any ideas? Thanks.

For Mike

Posted by A.R. on December 04, 2001 8:15 AM

Mark,

I tried the "data/subtotals/remove all" function but that didn’t work. It still shows the subtotal amount. Any ideas? Thanks.

Re: For Mark

Posted by Mike/Mark Whatever on December 04, 2001 8:39 AM

Try looking at Data/Consolodate.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.