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
September 27th, 2008 at 4:50 pm
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?