Remove Subtotals
Did you just get a spreadhseet that has subtotals (see picture) but you don’t know how to remove them?
1. Select the range (including headers) to remove subtotals
On the main menu bar
2. Click Data
3. Click Subtotals
4. Click the Remove All button and hit OK
An image of a sheet with subtotals

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!



I’m using Excel 2002 SP3. I’ve attempted to remove subtotals using the instructions above but it doesn’t seem to do anything. It’s a rather large file (1.6Mb) with many subtotals. Any suggestions?