Removing Subtotals  Average 42  3. Choose  Average  from the Auto Sum dropdown  2. Select the  Auto Sum  dropdown on the Formulas tab. 1. Select the cell directly beneath the range of data  2. Select  Remove All  to remove all subtotals. 1. Select the  Subtotal t ool  To remove subtotals from a data sheet:  The Subtotal Dialogue box will appear. To find the average of a select range of data: 