How to remove Subtotals

[nander]

I received an excel file with subtotals among groups of items. How do I extract only the sku#, description and total qty as a single row. I would like to sort the data etc.

[CLR]

Use a backup of course to try this to remove Subtotals.........

Highlight a cell in the field, then Data > Subtotals > Remove All

Vaya con Dios,
Chuck, CABGx3



"nander" wrote:

>
> I received an excel file with subtotals among groups of items. How do I
> extract only the sku#, description and total qty as a single row. I
> would like to sort the data etc.
>
>
> +-------------------------------------------------------------------+
> |Filename: DHN sales mix.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4384 |
> +-------------------------------------------------------------------+
>
> --
> nander
> ------------------------------------------------------------------------
> nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
> View this thread: http://www.excelforum.com/showthread...hreadid=514911
>
>