How To Remove Subtotals In Excel

excel how to get rid of subtotals
how do i remove subtotals in excel
how remove subtotals in excel
how to do subtotal remove all in excel
how to remove a subtotal in excel
how to remove all subtotals in excel
how to remove excel subtotals
how to remove subtotal excel
how to remove subtotal in excel
how to remove subtotals in excel
how to remove the subtotal in excel
how to undo subtotals in excel
remove subtotal in excel
how to take out a subtotal in excel
how to eliminate subtotals in excel
how to remove - from excel to show subtotal

Transcript of the video:

How do you remove Subtotals from Excel?
Your coworker added these. You can tell they were added by the subtotal command by these three little buttons out here, 1, 2 and three.
To get rid of them to choose one cell in the range that includes the subtotals.
On the Data tab, Far right-hand side, Click the Subtotal button.
And that's where the Remove All button is.
Click OK, that's the way to go.
If you try and remove the rows one at a time it will take too long.
And it won't get rid of the Group and Outline buttons.
If you like this video please visit TL.Page/MrExcel Scroll down, you'll find my group lessons and plenty more videos.
Thanks for watching