How to remove Subtotals

N

nander

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

+-------------------------------------------------------------------
|Filename: DHN sales mix.zip
|Download: http://www.excelforum.com/attachment.php?postid=4384
+-------------------------------------------------------------------
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top