Remove Subtotals

August 14th, 2004 | Categories: Data | Tags:
-->

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!
  1. September 27th, 2008 at 16:50
    Reply | Quote | #1

    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?