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?
Posted by Mike on December 04, 2001 7:38 AM
Click data/subtotals/remove all!
Posted by A.R. on December 04, 2001 8:15 AM
For Mark
Mark,
I tried the "data/subtotals/remove all" function but that didnt work. It still shows the subtotal amount. Any ideas? Thanks.
Posted by A.R. on December 04, 2001 8:15 AM
For Mike
Mark,
I tried the "data/subtotals/remove all" function but that didnt work. It still shows the subtotal amount. Any ideas? Thanks.
Posted by Mike/Mark Whatever on December 04, 2001 8:39 AM
Re: For Mark
Try looking at Data/Consolodate.
