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

Leave a Comment